Help with Harvey Ball formula

lucierosenthal

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!

Nic Larsen

Try: =IF(TODAY() > [End Date]@row, "Red", "")

Nic Larsen

Try: =IF(TODAY() > [End Date]@row, "Red", "")

lucierosenthal

That worked, thank you!! I had the today and end date flipped.