Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Date Time Difference AND

Topic Labels: Formulas
258 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Here is the formula I’m currently working with:

AND(
IF(
DATETIME_DIFF(TODAY(),{Date Status was Modified},‘days’) > 30), IF({Status} = “Open”)), “No”

I’m trying to say if the {status} field contains “Closed” AND if the {Date Status was Modified} is more than 30 days ago, then populate the formula field with “No”. I think I’m close, but I can’t get it to work. Any help would be greatly appreciated.

Thanks!

2 Replies 2

Here you go:

IF(
AND(
DATETIME_DIFF(TODAY(),{Date Status was Modified},'days') > 30,
{Status} = "Open"
),
"No")

Thanks @ScottWorld. That worked perfectly. I appreciate the quick response!