Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field with the months like you see in the picture
I want when clik to the my sheet, automatically select all month previous to the current date (and the actual month too)
Example:
Now i want to select month 01,02,03,04
thanks
Hi, sorry I read it too fast, i thought you wanted to select all months previous to the one clicked.
To select all months previous or equal to current month you can use: ='<=' &Num(Month(Today()))
Hi, you can try with triggers. In document properties -> triggers -> Field events -> select month field name -> add On select action.
Add a new Select on field action filling Name with the field name and Value With ='<=' &Max(MonthFieldName)
Hi, thanks you , but as you see, when i come inside my sheet it selected all months, not only
01,02,03,04
like i expect
Hi, sorry I read it too fast, i thought you wanted to select all months previous to the one clicked.
To select all months previous or equal to current month you can use: ='<=' &Num(Month(Today()))