Let’s divide this into chunks…
This could be done a couple different ways. The first option that many will attempt would be something like this:
OR({Phase/Status} = "Cancelled", {Phase/Status} = "Complete")
However, it could also be done this way:
REGEX_MATCH({Phase/Status}, "Cancelled|Complete")
I’ll use the latter option going forward, largely because it’s shorter.
Next chunk:
For this we’ll compare LAST_MODIFIED_TIME() against NOW() using DATETIME_DIFF():
DATETIME_DIFF(NOW(), LAST_MODIFIED_TIME(), "days") > 14
Each of those expressions will return True or False. To test if they’re both true, we can combine their logic using the AND() function:
AND(
REGEX_MATCH({Phase/Status}, "Cancelled|Complete"),
DATETIME_DIFF(NOW(), LAST_MODIFIED_TIME(), "days") > 14
)
Finally we’ll wrap that into an IF() function to create the desired output if both are True:
IF(
AND(
REGEX_MATCH({Phase/Status}, "Cancelled|Complete"),
DATETIME_DIFF(NOW(), LAST_MODIFIED_TIME(), "days") > 14
),
"Remove From Digest"
)
While some might be tempted to add the BLANK() function as a third argument in the IF() function, it’s not necessary. The IF() function is already designed to not return anything if that argument is omitted.
