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 ...
user avatar
  • 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....
user avatar
  • 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']]); ...
user avatar
  • 41.8k

Only top scored, non community-wiki answers of a minimum length are eligible