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.
Help Article Resources
Check out the Formula Handbook template!