Date Time Difference AND

[Brett_Smith1]

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!

[ScottWorld]

Here you go:

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

[Brett_Smith1]

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