If/And formula with date + text - help?

Hi! I am trying to add one layer of complexity to an IF formula.
The original formula is this:
IF(DATETIME_DIFF(TODAY(), {Date Last Updated}, ‘months’) > 24, “Possibly”)

But, before returning the value ‘Possibly,’ I want the formula to exclude all records that have a category called ‘Personal Posts’

This is what I’ve got thus far, but it’s not working. Any advice?

IF(AND(DATETIME_DIFF(TODAY(),{Date Last Updated}, ‘months’) > 24, (Primary Category}!=‘Personal Posts’), ‘Possibly’,)

Hey Lia, this formula should work:

IF(AND(DATETIME_DIFF(TODAY(),{Date last updated}, ‘months’) > 24, {Primary Category}!= ‘Personal Posts’), ‘Possibly’)

You have the wrong bracket at one point.

Unfortunately, it’s still not working! It’s giving me this error: “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.”

Can you post the formula you’re using and a screenshot of your table?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.