Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a button for a sheet to filter for all dates less than TODAY using the 'TODAY' Expression, but have not been successful so far. Any ideas?
You can add a flag field to your mastercalendar in the script that flags all dates that are earlier than today, today and in the future, for example:
If(DateField < Today(), 'Past', If(DateField = Today(), 'Today', 'Future')) as DateSortFlag
Add a filter object with the dimension field DateSortFlag to the sheet and users are able to select dates from the past in one click.
Hope it helps!