Need Help w/Nested If

6 years ago
April 23, 2018
1 reply
0 views

maurice_nusom
New Participant

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.

Jeremy_Oglesby
Inspiring
6 years ago
April 23, 2018

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

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

Reply