# Harvey Ball formula based on dates

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!

Tags:

• ✭✭✭✭✭✭

Close. Try this (updates in bold):

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

• ✭✭✭✭✭✭

Close. Try this (updates in bold):

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

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

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!