How to use multiple IF and AND functions for symbol formula

Curtis
Curtis ✭
edited 03/14/23 in Formulas and Functions

Hello Everyone,

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

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!