Automating RYG Status Balls Based Off Two Date Columns
I have two columns "Actual Start Date" and "Actual End Date", I want to have a formula for the status column using the RYG Status balls that will:
- Red when nothing is in either of the two cells
- Yellow when there is a date in the "Actual Start Date" Column
- Green when a date has been entered into both
Help Article Resources
Check out the Formula Handbook template!