Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
In the 'Sheet Properties' -> Trigger -> On Activate Sheet ->
Select In Field -> Field (Month field)
Search String -> =Date(Max({1}Date),'MMM')
In the 'Sheet Properties' -> Trigger -> On Activate Sheet ->
Select In Field -> Field (Month field)
Search String -> =Date(Max({1}Date),'MMM')
Go to 'Sheet Properties' -> Trigger -> On Activate Sheet ->
Select In Field -> Field (Monthname)
Search string- =maxstring(Monthname)
Thanks a lot!
Thank you!)
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 .