Hello!
I am relatively new to Airtable and am trying to figure out why my nested IF statement isn’t working.
Goal: If the due date field value is before today and the field complete is not checked show “in progress”, if complete is checked then show todays date if none of the above are true show “missed”.
Current Formula:
IF({Due Date} IS_BEFORE({Due Date}, TODAY()),“In progress”, IF(Complete=1 ,DATETIME_FORMAT(TODAY(),“l”),“Missed”))
I may be using the wrong formula as well. I tried a few variations and couldn’t get it to work. Any help would be great! Thanks!
This issue seems similar to this but not quite the same: Problem in my Nested IF-THEN-ELSE statement