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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!