Raise Flag: If and statement
Paige Luben
✭✭✭✭
Trying to put in a formula that raising the flag if the end date is past the deadline and status is not marked as complete. This is the formula I have =IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete"), 1, 0)) but it is returning #UNPARSEABLE
Tags:
Best Answers
-
Looks like the AND closing bracket is misplaced. Would this work:
=IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete")), 1, 0)
-
Thank you so much!!!
Answers
-
Looks like the AND closing bracket is misplaced. Would this work:
=IF(AND([End Date]5 > Deadline5, NOT(Status5 = "Complete")), 1, 0)
-
Thank you so much!!!
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!