Skip to main content
Solved

Creating conditional formula that doesn't calculate if Status field says "Completed"

A

Very new to Airtable and having some fun with formulas.

I have project records with a simple status field (Planned, In Progress, Completed) and some basic date fields.

I created a formula that checks if the project is "On time" or "Overdue" based on the completed (planned or actually completed) date field vs today.

I don't need this formula to calculate on Completed projects so i'm looking for a formula that sets the field to blank if status is Completed, but calculates if Planned or In Progress.

Current checking formula:

IF({Completed Date} < NOW(), "Overdue", IF(IS_SAME({Completed Date}, TODAY(), 'day'), "At Risk", "On Time"))

Best answer by Mike_AutomaticN

Hey @AdamZame!

You’ll want to have a nested IF formula. Please give this a shot and let me know if it works for you:

IF(
{Status} = "Completed",
BLANK(),
IF(
{Completed Date} < NOW(),
"Overdue",
IF(
IS_SAME({Completed Date}, TODAY(), 'day'),
"At Risk",
"On Time"
)
)
)

 

Mike, Consultant @ Automatic Nation

View original
Did this topic help you find an answer to your question?

3 replies

Mike_AutomaticN
Forum|alt.badge.img+9

Hey @AdamZame!

You’ll want to have a nested IF formula. Please give this a shot and let me know if it works for you:

IF(
{Status} = "Completed",
BLANK(),
IF(
{Completed Date} < NOW(),
"Overdue",
IF(
IS_SAME({Completed Date}, TODAY(), 'day'),
"At Risk",
"On Time"
)
)
)

 

Mike, Consultant @ Automatic Nation

A
1 person likes this
  • A
    AdamZame
A
  • AdamZame
  • Author
  • New Participant
  • 1 reply
  • January 20, 2025
Mike_AutomaticN wrote:

Hey @AdamZame!

You’ll want to have a nested IF formula. Please give this a shot and let me know if it works for you:

IF(
{Status} = "Completed",
BLANK(),
IF(
{Completed Date} < NOW(),
"Overdue",
IF(
IS_SAME({Completed Date}, TODAY(), 'day'),
"At Risk",
"On Time"
)
)
)

 

Mike, Consultant @ Automatic Nation


Thanks Mike,
That worked great. 

Mike_AutomaticN
Forum|alt.badge.img+9

Always happy to help @AdamZame!

If you have any other Airtable related question, feel free to schedule a call using this link!

Mike, Consultant @ Automatic Nation

 

Reply


Most helpful members this week

Terms & Conditions