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.
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.”
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.