This content has been marked as final. Show 2 replies
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?