Apr 23, 2018 12:19 PM
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.
Apr 23, 2018 12:56 PM
IF(Complete = 1, “Complete”, IF(IS_BEFORE({Due Date}, TODAY()),“Overdue!”, “In Progress”))
Try that - I think you just had some erroneous parentheses.