Harvey Ball formula with Expiry dates

Hello, I am going crazy, I have been through the community posts and tried to figure out this myself with no success.

I want a Red ball to appear if the date in the CV Expiry Date column is less than a week away, or in the past.

I want a Yellow ball to appear if the date is in the next 30 days, and Green if it's more than 30 days away.

Please help!!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!