Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want, on activate a sheet, always select the last year.
I do not want to select a year but always the last 12 months.
Try putting a variable in the load script. Then use a button trigger rather than sheet activated trigger (I haven't had good luck with them in ajax).
Variable (in load script)
Let vminus12 = addmonths(yourdate,-12)
In button, Triggers > Select in Field (enter your date field). Use: ='>='&'$(vminus12)' in the Search field.
Give it a shot and let me know if it works.