Formula for enabling heath column colored dots
I am trying to enable the colored dots in the health column based on planned start/finish and actual start/finish. I have tried many different formulas and none has worked so far.
Here is what I am trying to achieve,
If "Status" = On Hold or Cancelled -> Enable blue dot
If "Start Date">"Actual Start" -> Enable yellow dot
If "End Date"<"Actual Finish" -> Enable red dot
If "End Date">="Actual Finish" -> Enable green dot
Any guidance would be much appreciated.
Help Article Resources
Check out the Formula Handbook template!