9 Replies Latest reply: Jul 23, 2013 1:09 PM by Peter Schulz RSS

    Trigger for Selection of actual + next 10 weeks

    Peter Schulz



      I have set a triggers for a sheet to select the actual week:


      Field: Year

      Search String: =Year(today(2))



      Field: week

      Search String: =Week(today(2))


      Is it possible to change the search string that I get the next 10 weeks selected too. And what can I do that this works at the end of the year.


      I think there will be a problem if I select week 50 and want the next 10 weeks selected too.


      Thanks in advance for your help.


      - PS -