Trigger to select current week by default when a tab is opened

[apoorvasd]

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.

[sunny_talwar · Accepted solution]

Try this for Select in Field search string

=Min({<WeekShort = {"$(='>=' & Date(Today()))"}>}WeekShort)

[apoorvasd]

Yes, that worked!

Thanks a lot