3 Replies Latest reply on Jun 20, 2018 10:09 AM by Alex Braun

    Dynamic Week numbers based on a flag

    Vedant Chaturvedi

      Hi All,

       

      I have a requirement to show where if a flag is 'Yes' for 3/4/2018 and onward dates, I need to flag the week of 3/4 as Week 1, next as Week 2 and so on.

      This flag will keep changing over time to have different dates flagged. So, the solution needs to be dynamic where the Week 1 changes based on this flag.

       

      I have tried taking out the week start date and end date, but it shows 'Week 1' for all subsequent weeks as they are also flagged as 'Yes'.

       

      I am stuck on this for a while now and any help would be greatly appreciated.

       

      Thanks!

      Vedant