I currently have a gannt chart concept showing 40 repetitions. 1 field is by week and shows dates, ie;
25 | 1 | 8 | 15 | 22 | 29 | etc...
I would like another field with the same repetitions fill a color with conditional formatting. So the field showing "1" would be color filled.
My current conditional formatted formula is:
GetRepetition (Schedules::zc__date__rgd ;Get ( CalculationRepetitionNumber )*7) = Get ( CurrentDate )
note: "Schedules::zc__date__rgd" represents the schedule viewable start date.
What is wrong with the formula, as nothing fills on the appropriate date?