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!

-Andrea

Comments

  • Connor Hartford
    Connor Hartford ✭✭✭✭✭✭

    Hi Andrea,

    You'll want to use the formula like this:

    =IF(AND(Stand2<>"Complete", [Due Date]<= TODAY()),1,"")

    If this the data for this formula is in the same row as the formula, I would write it this way:

    =IF(AND([Stand]@row&lt;>"Complete", [Due Date]@row&lt;= TODAY()),1,"")

    Connor


    Connor Hartford

  • Andrea Mayer
    Andrea Mayer ✭✭✭✭✭✭

    Thank you, Connor! This worked perfectly.

Help Article Resources