AnsweredAssumed Answered

Conditional formatting to repetition field?

Question asked by tomperr on Sep 6, 2017
Latest reply on Sep 6, 2017 by tomperr

I currently have a gannt chart concept showing 40 repetitions.  1 field is by week and shows dates, ie;

Aug   Sept

  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?

Outcomes