Help

Need Help w/Nested If

925 1
cancel
Showing results for 
Search instead for 
Did you mean: 
maurice_nusom
4 - Data Explorer
4 - Data Explorer

I am trying to use this nested if statement, not sure what I am doing wrong but I keep getting an error when trying to save it.

IF(Complete = 1, “Complete”, IF(IS_BEFORE(({Due Date}), TODAY()],“Overdue!”, “In Progress”))

Thank you for your help.

1 Reply 1

IF(Complete = 1, “Complete”, IF(IS_BEFORE({Due Date}, TODAY()),“Overdue!”, “In Progress”))

Try that - I think you just had some erroneous parentheses.