How to use multiple IF and AND functions for symbol formula
I have a basic project sheet with Start Date, End Date, % Complete Columns.
I would like a formula for Symbols to do the following:
Gray = If todays date is less than Start Date
Red = If todays date is greater than due date AND % Complete is less than 100
Yellow = If todays date is less than due date AND % Complete is blank or 0
Green = If % Complete = 100
Thank you for your help! 😊
Help Article Resources
Check out the Formula Handbook template!