Author Topic: Google Sheets help  (Read 3030 times)

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4854
  • Total likes: 528
  • DansDeals.com Hat Tips 21
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #30 on: May 03, 2019, 12:29:05 PM »
Is there a way to delete cells on GS mobile?
Memories last forever, make them while you can.

Offline User6669

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3188
  • Total likes: 123
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #31 on: May 03, 2019, 01:04:12 PM »
Is there a way to delete cells on GS mobile?
If you select the cell/cells and do a long press, one of the options should be "clear". If you don't see it make sure you have permission to edit...
".איזהו חכם, הלומד מכל אדם"

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4854
  • Total likes: 528
  • DansDeals.com Hat Tips 21
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #32 on: May 03, 2019, 02:13:33 PM »
If you select the cell/cells and do a long press, one of the options should be "clear". If you don't see it make sure you have permission to edit...
That clears it, but I want to delete it and move up the cells below it, as I would on a PC.
Memories last forever, make them while you can.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #33 on: May 27, 2019, 02:47:28 PM »
I have an IMPORTXML formula which returns results like this:

Code: [Select]
A
1
B
2
C
3

Is there any way to wrap the formula in something which would have the results display like this?
Code: [Select]
A    1
B    2
C    3
?

TIA
Workflowy. You won't know what you're missing until you try it.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7172
  • Total likes: 270
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: Google Sheets help
« Reply #34 on: May 28, 2019, 07:25:17 AM »
=A2
=A4
Auto fill
Then delete them from a:a

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #35 on: May 28, 2019, 09:30:57 AM »
=A2
=A4
Auto fill
Then delete them from a:a
Thanks for answering! I can do that but I was looking for something to wrap the entire table in, that would produce an array, so I don't have to drag /modify each time the IMPORTXML changes.
Workflowy. You won't know what you're missing until you try it.

Offline MendelGordon

  • DansDeals Copper Elite
  • *
  • Join Date: Mar 2019
  • Posts: 7
  • Total likes: 0
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Los Angeles
Re: Google Sheets help
« Reply #36 on: June 04, 2019, 03:17:01 PM »
Anyone have a script that works on mobile sheets for automatically showing the tracking status next to every tracking number I put in?  I have one but it only works for UPS (you switch L8 for the cell you have the tracking number in)
=index(IMPORTXML("https://wwwapps.ups.com/tracking/tracking.cgi?tracknum="&L8,"//*[contains(@class,'ups-group')]"),2)

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #37 on: June 04, 2019, 06:46:19 PM »
Try this:
Code: [Select]
=query(importxml("http://www.boxoh.com/?t="&L8,"//div[([member=17672]ID[/member] ='container')]"),"SELECT Col1")
(I haven't tried it on mobile but looks like it works on desktop)
Workflowy. You won't know what you're missing until you try it.

Offline MendelGordon

  • DansDeals Copper Elite
  • *
  • Join Date: Mar 2019
  • Posts: 7
  • Total likes: 0
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Los Angeles
Re: Google Sheets help
« Reply #38 on: June 06, 2019, 07:16:56 PM »
Try this:
Code: [Select]
=query(importxml("http://www.boxoh.com/?t="&L8,"//div[([member=17672]ID[/member] ='container')]"),"SELECT Col1")
(I haven't tried it on mobile but looks like it works on desktop)
Not working for me, just shows N/A

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #39 on: June 06, 2019, 07:21:39 PM »
Can you try visiting this link but putting your tracking # at the end, and see if it shows you anything?
http://www.boxoh.com/?t=
Workflowy. You won't know what you're missing until you try it.

Offline MendelGordon

  • DansDeals Copper Elite
  • *
  • Join Date: Mar 2019
  • Posts: 7
  • Total likes: 0
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Location: Los Angeles
Re: Google Sheets help
« Reply #40 on: June 16, 2019, 02:38:21 PM »
Can you try visiting this link but putting your tracking # at the end, and see if it shows you anything?
http://www.boxoh.com/?t=
Yep, that works

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #41 on: June 16, 2019, 02:40:55 PM »
Hmm.. try this:

=query(importxml("http://www.boxoh.com/?t="&L8,"//div[(@id ='container')]"),"SELECT Col1")

Looks like BBC messed it up before
Workflowy. You won't know what you're missing until you try it.

Offline hide4

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2015
  • Posts: 1340
  • Total likes: 23
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: NY-Israel
Re: Google Sheets help
« Reply #42 on: July 25, 2019, 03:34:29 PM »
Is there any way to Email Collaborators while using Google Sheets on mobile?

Offline Am

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Nov 2011
  • Posts: 947
  • Total likes: 1
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Google Sheets help
« Reply #43 on: September 09, 2019, 03:49:04 PM »
Is there a way to trace Dependent or Precedent Cells in Google Sheets?
It's such a basic and easy to use feature in Excel but I can't seem to figure it out in Sheets.
TIA.

P.S. Sorry to cross post, but I posted this this in the Excel help thread 10 days ago and didn't get a reply. I thought maybe this thread might have people more knowledgeable in Sheets.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9385
  • Total likes: 312
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Workflowy. You won't know what you're missing until you try it.