How to set trigger on select in field?

[Anonymous]

Hi!

Could you help me with a little problem?)

I have two calendars organized through a listbox. One calendar for one sheet, the second for another. When moving from one project sheet to another, I need to select the maximum month in calendars.

How to set trigger or smthng else?

[settu_periasamy · Accepted solution]

In the 'Sheet Properties' -> Trigger -> On Activate Sheet ->

Select In Field      -> Field (Month field)

    Search String -> =Date(Max({1}Date),'MMM')

[neha_shirsath]

Go to 'Sheet Properties' -> Trigger -> On Activate Sheet ->

Select In Field      -> Field (Monthname)

Search string- =maxstring(Monthname)

[Anonymous]

Thanks a lot!

[Anonymous]

Thank you!)

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .