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
Sep 29, 2021 12:00 PM
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
Solved! Go to Solution.
Sep 29, 2021 12:18 PM
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"
)
)
)
Sep 29, 2021 12:18 PM
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"
)
)
)
Sep 29, 2021 01:01 PM
This works great, thank you!!!