Help with a date / Harvey ball formula

Hi - Smartsheet Community,

I'm trying to setup a similar formula but using a date column. I have a column titled Revision Date. I would like to add a column titled Status for the Harvey balls (red, yellow and green) to indicate the following:

If revision date is 365 days older than current calendar date display a red Harvey ball.

If revision date is 275 to 364 days older than current calendar date display a yellow Harvey ball.

If revision date is 1 to 274 days older than current calendar date display a green Harvey ball.

Any help is greatly appreciated. Thank you - Sha

Best Answer

Answers

  • Hi Mike,

    It worked PERFECTLY! Thank you for the quick reply.

    Best wishes - Sha

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!