Formula with multiple IF criteria
Andrea Mayer
✭✭✭✭✭✭
Hi all 
Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error.
=IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1)
I am not sure that I am combining the two statesments correctly. Can anyone help with this?
Appreciate the help!
Andrea
Comments

Thank you, Connor! This worked perfectly.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!