Formula woes

Options

Fairly new to Smartsheet and I can't get my formula to work, this is what I am trying do:

If Due Date in Children row is less than today and Status is Not Started "Red", In Progress "Yellow", Done and in Review "Blue", Complete and Closed "Green".

Thank you in advance!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!