Help with Harvey Ball formula
I have both "start date" and "end date" columns in my sheet, as well as a "status" column with yellow, red, green, and gray harvey balls. I want the color of the harvey ball to turn to red when it is past the end date. Is there a formula that can do that for me? I only want to automate red harvey balls, not the other colors. Thank you!
Best Answer
-
Try: =IF(TODAY() > [End Date]@row, "Red", "")
Answers
-
Try: =IF(TODAY() > [End Date]@row, "Red", "")
-
That worked, thank you!! I had the today and end date flipped.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!