Skip to main content

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!

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!

Reply


Terms & Conditions