Author Topic: Google Sheets help  (Read 15394 times)

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

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12862
  • Total likes: 3317
  • 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: 1437
  • Total likes: 29
  • 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: 997
  • Total likes: 13
  • 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.

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12862
  • Total likes: 3317
  • 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.

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1748
  • Total likes: 480
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Google Sheets help
« Reply #45 on: January 19, 2021, 03:46:22 PM »
I want to have a date AND time timestamp autopopulate in column A when editing column B

I found some code here https://spreadsheetpoint.com/insert-timestamps-in-google-sheets/

I edited it as follows
Code: [Select]
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "New transactions" ) { //checks that we're on the correct page or not
var r = s.getActiveCell();
if( r.getColumn() == 2 ) { //checks that the cell being edited is in column B
var nextCell = r.offset(0, -1);
if( nextCell.getValue() === '' ) //checks if the adjacent cell is empty or not?
nextCell.setValue(new Date());
}
}
}

It works but only adds in the date is there some function to replace
Code: [Select]
nextCell.setValue(new Date()); that would include the current time?

I tried NOW() but it doesn't seem to work
My Tapatalk notifications don't always work.

Online Euclid

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4911
  • Total likes: 6142
  • DansDeals.com Hat Tips 5
    • View Profile
Re: Google Sheets help
« Reply #46 on: January 19, 2021, 03:48:48 PM »
I want to have a date AND time timestamp autopopulate in column A when editing column B

I found some code here https://spreadsheetpoint.com/insert-timestamps-in-google-sheets/

I edited it as follows
Code: [Select]
function onEdit() {
var s = SpreadsheetApp.getActiveSheet();
if( s.getName() == "New transactions" ) { //checks that we're on the correct page or not
var r = s.getActiveCell();
if( r.getColumn() == 2 ) { //checks that the cell being edited is in column B
var nextCell = r.offset(0, -1);
if( nextCell.getValue() === '' ) //checks if the adjacent cell is empty or not?
nextCell.setValue(new Date());
}
}
}

It works but only adds in the date is there some function to replace
Code: [Select]
nextCell.setValue(new Date()); that would include the current time?

I tried NOW() but it doesn't seem to work
It should include the time too; check what the cell is formatted as.

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1748
  • Total likes: 480
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Google Sheets help
« Reply #47 on: January 19, 2021, 03:52:54 PM »
It should include the time too; check what the cell is formatted as.
Ahh you're right.
Thanks
My Tapatalk notifications don't always work.

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6657
  • Total likes: 2588
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #48 on: January 28, 2021, 08:46:35 PM »
Anyone here know how to get text from a specific url (either by looking up it's id or find specific text) using Google app script?
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12862
  • Total likes: 3317
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #49 on: January 28, 2021, 08:57:34 PM »
Anyone here know how to get text from a specific url (either by looking up it's id or find specific text) using Google app script?
Have you tried IMPORTHTML() or IMPORTXML() functions to see if they do what you need?
Workflowy. You won't know what you're missing until you try it.

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6657
  • Total likes: 2588
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #50 on: January 28, 2021, 09:11:03 PM »
Have you tried IMPORTHTML() or IMPORTXML() functions to see if they do what you need?
I specifically need it an a app script
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12862
  • Total likes: 3317
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #51 on: January 28, 2021, 09:29:30 PM »
I specifically need it an a app script
got it. hopefully someone else can help then!
Workflowy. You won't know what you're missing until you try it.

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6657
  • Total likes: 2588
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #52 on: February 12, 2021, 01:53:11 AM »
Anyone familiar with using UrlFetchApp?
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline Definitions

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2018
  • Posts: 1748
  • Total likes: 480
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Google Sheets help
« Reply #53 on: March 08, 2022, 12:45:08 AM »
Is there a way to automatically add a blank row after every entry?
Meaning I want it to be active on one column that if it was previously blank and you filled something in and pressed enter/tab or just leave the cell it will add a new row on bottom of that.
« Last Edit: March 08, 2022, 12:49:36 AM by Definitions »
My Tapatalk notifications don't always work.

Offline as2

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2013
  • Posts: 5671
  • Total likes: 917
  • DansDeals.com Hat Tips 24
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #54 on: March 08, 2022, 08:20:35 PM »
Is there a way to automatically add a blank row after every entry?
Meaning I want it to be active on one column that if it was previously blank and you filled something in and pressed enter/tab or just leave the cell it will add a new row on bottom of that.
I believe shift+enter will add a new row. Not exactly automatic, but easier than having to shift from keyboard to mouse.
Memories last forever, make them while you can.

Online Yo ssi

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Aug 2019
  • Posts: 6657
  • Total likes: 2588
  • DansDeals.com Hat Tips 60
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #55 on: March 08, 2022, 08:51:30 PM »
Not very clear to me what your trying to do, but it should definitely be possible with an app script
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline SamDaMan

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Sep 2010
  • Posts: 585
  • Total likes: 29
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: cleveland rox!
Re: Google Sheets help
« Reply #56 on: March 31, 2022, 10:50:46 AM »
i have a google sheets where i keep track of all my items that we import each line has the model number, cost, container number, ship date, landing date etc..

since there are so many its hard to see exactly which models are coming when.  i would like to have sheets (named by the model number) for each model number so that when we add a line onto the main sheet it should copy straight into the correct sheet. that way i can see each model separately.

what would be the best way to do this?
But I'm still proud to be from clev!

Online etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 12862
  • Total likes: 3317
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #57 on: March 31, 2022, 10:52:08 AM »
what would be the best way to do this?
likely not google sheets...
Workflowy. You won't know what you're missing until you try it.

Online whacked1

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Oct 2012
  • Posts: 2556
  • Total likes: 518
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Google Sheets help
« Reply #58 on: March 31, 2022, 10:55:14 AM »
i have a google sheets where i keep track of all my items that we import each line has the model number, cost, container number, ship date, landing date etc..

since there are so many its hard to see exactly which models are coming when.  i would like to have sheets (named by the model number) for each model number so that when we add a line onto the main sheet it should copy straight into the correct sheet. that way i can see each model separately.

what would be the best way to do this?
This should be fairly simple with appsheet

Offline SamDaMan

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Sep 2010
  • Posts: 585
  • Total likes: 29
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: cleveland rox!
Re: Google Sheets help
« Reply #59 on: March 31, 2022, 12:51:42 PM »
thanks. will check out appsheet
But I'm still proud to be from clev!