1
vote
How to transpose (rotate) entire Google Sheets sheet?
Select the entirety of your data then go to a new sheet where we will be placing the transposed version. Simply right click > Paste Special > Transposed.
This should carry over all conditional ...
- 531
1
vote
Accepted
Hiding columns based on date
You can hide columns that do not meet your criteria with an onOpen(e) simple trigger.
To easily compare a date in row 1 to today's date, you can get the dates as text strings with Range....
- 6,523
1
vote
Accepted
add timestamp to this code
Instead of setNumberFormat use setNumberFormats, i.e.
firstBlankCell
.offset(0, 0, values.length, values[0].length)
.setValues(values)
.setNumberFormats([['dd.MM.yyyy','hh:mm:ss', '0']]);
...
- 41.8k
Only top scored, non community-wiki answers of a minimum length are eligible