Harvey Ball formula based on dates

Jenelle.A.Abrams

Hello,

I have Revision Due column and I would like to automate the Harvey Ball formula that if the Revision Due date is older than today's date the ball would be Red.

If the Revision Due date is within 60 days of today the ball would be yellow.

If the Revision Due date is days the ball would be green.

I've tried the formula below but I keep getting the #unparseable error.

=IF([Revision due] >= TODAY(), "Red", IF([Revision Date] <= TODAY([+60]), "Yellow", "Green"))

Any help is appreciated as I learn my way through Smart Sheet. I know there are plenty of questions similar but when I've tried to edit the existing solutions to match my sheet I'm having a hard time. Thanks!

Paul Newcome

Close. Try this (updates in bold):

=IF([Revision Due]@row < TODAY(), "Red", IF([Revision Due]@row <= TODAY(60), "Yellow", "Green"))

Paul Newcome

Close. Try this (updates in bold):

=IF([Revision Due]@row < TODAY(), "Red", IF([Revision Due]@row <= TODAY(60), "Yellow", "Green"))

Jenelle.A.Abrams

https://community.smartsheet.com/discussion/comment/334685#Comment_334685

Thank you so much Paul! This worked like a dream.

Paul Newcome

Happy to help. 👍️