2 Replies Latest reply: Oct 3, 2017 10:36 AM by Apoorva Dhulehole RSS

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

    Apoorva Dhulehole

      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.