I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and follow the right syntax. Here are my conditions I am trying to meet.
TIA for your help.
Grey
- If TODAY < [Start] and [Task Started] not checked
OR
- If TODAY< [Finish] and [Task Completed] not checked
Red
- If TODAY > [Start] and [Task Started] not checked
OR
- If TODAY> [Finish] and [Task Completed] not checked
Yellow
- If TODAY equal to or less than [Start] and [Task Started] not checked
OR
- If TODAY equal to or less than [Finish] and [Task Completed] not checked
Green
- If TODAY equal to or less than [Start] and [Task Started] is checked
OR
- If TODAY equal to or less than [Finish] and [Task Completed] is checked