Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
How can I set a sheet trigger which applies the condition that, when a that tab is opened by default latest week to which the current date belongs to should be selected?
For example, as today's date is 3rd October 2017, when I open tab, "Sheet1" in the app attached, by default in my week field (WeekShort), 06/10/2017 should be chosen as 3rd Oct belongs to this week as per my data in the attached excel sheet. How can I achieve this?
Thank you.
Try this for Select in Field search string
=Min({<WeekShort = {"$(='>=' & Date(Today()))"}>}WeekShort)
Try this for Select in Field search string
=Min({<WeekShort = {"$(='>=' & Date(Today()))"}>}WeekShort)
Yes, that worked!
Thanks a lot