Creating formula field for determining "In progress", "Overdue"

Hello,

I’m trying to create a formula field that will return a value of “Overdue” or “In Progress” based on the values of 2 other fields: Writer Due Date and Status. Here’s what I’m trying to achieve:

IF the Status is any of the following: In Progress, Awaiting Information (Outreach 1), Awaiting Information (Outreach 2), Awaiting Information (Outreach 3), AND the Writer Due Date is BEFORE the provided deadline, then the field returns “In Progress”.

IF the Status is any of the following: In Progress, Awaiting Information (Outreach 1), Awaiting Information (Outreach 2), Awaiting Information (Outreach 3), AND the Writer Due Date is AFTER the provided deadline, then the field returns “Overdue”.

How would I write this as a formula? Thanks in advance

IF(
   OR(
      {Status} = "In Progress",
      {Status} = "Awaiting Information (Outreach 1)",
      {Status} = "Awaiting Information (Outreach 2)",
      {Status} = "Awaiting Information (Outreach 3)"
   ),
   IF(
      {Writer Due Date} < TODAY(),
      "In Progress",
      IF(
         {Writer Due Date} >= TODAY(),
         "Overdue"
      )
   )
)

This works great, thank you!!!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.