Formula with multiple IF criteria

Andrea Mayer
Andrea Mayer ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!