Complicated if statement - health column

Hi All,

I'm really hoping you can help me.

We have a project tracker that has below columns:

Client Type (platinum, gold or silver), Delivery Date, Aging, Status, Health.

The health column is a symbol column with green, yellow and red colours. We need the formula to indicate the below requirements:

I've been trying for days now but can't come up with such formula so any help would be much appreciated here please!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!