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 ...
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....
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']]);
...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-apps-script × 1692google-sheets × 1422
google-forms × 118
google-apps-script-triggers × 116
google-docs × 90
formulas × 88
google-sheets-timestamp × 77
google-drive × 70
google-sheets-custom-function × 64
gmail × 53
google-apps × 53
javascript × 44
google-sheets-query × 32
google-sheets-arrayformula × 25
sorting × 19
conditional-formatting × 18
google-calendar × 15
google-sheets-dates × 15
importrange × 15
google-contacts × 12
google-sheets-macro × 12
google-apps-script-add-on × 12
automation × 11
data-validation × 11
google-sheets-charts × 10