Formula with multiple IF criteria
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!