Help

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

Topic Labels: Formulas
Solved
Jump to Solution
988 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Aysia_Saylor
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus
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"
      )
   )
)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus
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!!!