'Hide / Unhide Columns based on date
My spreadsheet has a sheet containing a timeline in row 2
I want to hide / unhide columns based on today's date
First there should be a function onEdit hiding all columns except the first fixed 3 up to the column next to today and go to the first unhidden column.
Second a function which shows a similar view but 3 more columns in the past
Third a function which shows a similar view but 12 more columns in the past
Fourth unhide the complete sheet
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|