Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
340 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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
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!!!