Nest IF statement with an AND embedded for RYG

Options

I am struggling to create a statement that would say:

IF the finish date is less than three days away AND the percentage is less than 60% then RED, If the finish date is less than three days away and is less than 75% complete then YELLOW, and the rest is green...

Any help?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!