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

Topic Labels: Formulas
Solved
563 2
cancel
Showing results for
Did you mean:
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
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"
)
)
)
``````
2 Replies 2
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"
)
)
)
``````
6 - Interface Innovator

This works great, thank you!!!