RE verification of line item formula from SYS01 Time Setting by week module

[abhi12K]

Hi ,

Please guide me if i used wrong formulae for below line item.

Thanks

[JaredDolich · Accepted solution]

@abhi12K

You have two options for this line item.

1. Leave it editable and just check the first week as TRUE.
2. Use this formula: OFFSET(1, -1, 0) = 0. This will go back one period. If it's not a valid period then it will equal zero and set this formula to TRUE.