Help

Date Time Difference AND

Topic Labels: Formulas
752 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brett_Smith1
5 - Automation Enthusiast
5 - Automation Enthusiast

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")
Brett_Smith1
5 - Automation Enthusiast
5 - Automation Enthusiast

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