Multiple If/And Statements

Katie Cobb
Katie Cobb ✭✭
edited 12/09/19 in Smartsheet Basics

I am trying to work through multiple if/and statements to use red/yellow/green/gray indicators without much luck.  Essentially, I would like the formula to produce the following:

If % Complete = 1, Green

If % Complete < 1, and finish date is within 7 days, Red

If % Complete < 1, and finish date is within 14 days, Yellow

If % Complete < 1, and finish date is over 15 days, Gray

 

Any help would be appreciated!

Thank you

Comments