Skip to main content

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.

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



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

Reply


Terms & Conditions