Complicated if statement - health column
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!
Help Article Resources
Check out the Formula Handbook template!