5,028 reputation
21039
bio website vvv.vidarramdal.com
location Oslo, Norway
age 37
visits member for 2 years, 7 months
seen 48 mins ago

Java and web developer located in Oslo, Norway.

Heavy Google Apps user and spreadsheet nerd.


1h
comment How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
In my last version, I used Utilities.formatDate(startDate, ...) while the current edit says Utilities.formatDate(new Date(startDate), ...). Not sure why you would need to wrap startDate in new Date, provided you have a date in A3.
10h
comment How to recover a Picasa account username
possible duplicate of How do I recover my Google password or username?
11h
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Title
11h
comment How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Ahh ... of course. So you would need to know the timezone, obviously. Thanks again!
11h
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Rewritten to use Utilities, thanks @JacobJanTuinstra
11h
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Rewritten to avoid using toISOString
13h
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Updated per the OP's request
14h
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Updated as per OP's request
1d
awarded  Copy Editor
1d
revised How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
Dethank, formatting
1d
answered How do I get a date formatted as YYY-MM-DD from a cell for using in a script?
1d
reviewed Close who has me in their google+ circles?
1d
reviewed Reviewed What authentication methods are supported for Cognito Forms connecting to Sharepoint?
1d
revised What authentication methods are supported for Cognito Forms connecting to Sharepoint?
Formatting
1d
reviewed Reviewed How to add adjacent cells in Google Sheets
1d
comment How to add adjacent cells in Google Sheets
Not sure I understand - could you specify what your expected result would be for "Annie"?
1d
reviewed Reviewed Why can I rearrange my Apps Grid for some accounts but not others?
1d
comment Why can I rearrange my Apps Grid for some accounts but not others?
I would be very careful with installing extensions from other places than the Chrome Web Store.
1d
revised Why can I rearrange my Apps Grid for some accounts but not others?
Formatting
1d
reviewed Close Facebook: posting versus linking versus sharing (and using Facebook for promoting one's image / self-advertising)?