I am trying to automate the RYG ball status column, based on several factors.
Red
- if not marked 100% complete in the [% Complete] column after the [End Date] or;
- if less than 7 days before [Start Date] and [RS] and [WOA] are not both =1
Yellow
- If greater than 7 days before [Start Date], [RS] and [WOA] are not both =1
Green
- If today is before [End Date] and [RS] and [WOA] are both =1
Blue
- If [% Complete] = 100%
[% Complete] is formatted for %
[Start Date} and [End Date] are of course, formatted as dates.
[RS] and [WOA] are both check boxes.
I end up getting turned around in nested IF statements and am ready to pull my hair out...