Select multiple months in a field

[danosoft]

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

[danosoft]

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

[rubenmarin]

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)

[danosoft]

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

[rubenmarin · Accepted solution]

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()))