Need Help w/Nested If


#1

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.


#2

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

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