Harvey Ball formula with Expiry dates

RGarrels

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!!

Paul Newcome

You would use something like this:

=IF([Date Column]@row<= TODAY(7), "Red", IF([Date Column]@row<= TODAY(30), "Yellow", "Green"))

RGarrels

Thank you! I had the Red and the Yellow in the wrong order.

RGarrels

One more question! How do I also make it blank if there is nothing in the date column?

Paul Newcome

Try this:

=IF([Date Column]@row <> "", IF([Date Column]@row<= TODAY(7), "Red", IF([Date Column]@row<= TODAY(30), "Yellow", "Green")))