Long formula for Status balls with 2 criteria
I have a tracker that needs a Status column using Harvey balls.
There are columns for 6 mon, 12 mon, and 24 mon MIN and MAX and Completed Visit scheduling dates, and the Project Manager is asking for a Status column that will show whether there is a visit past due, coming up, or completed based on the colored balls.
(I struggle with creating complex formulas in the right order so that they work).
The formula needs to:
Help Article Resources
Check out the Formula Handbook template!