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

    Trigger for Selection of actual + next 10 weeks

    Peter Schulz

      Hi,

       

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

      Action1:

      Field: Year

      Search String: =Year(today(2))

       

      Action2:

      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 -