Harvey Ball formula based on dates



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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!