Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If/And formula with date + text - help?

Topic Labels: Formulas
326 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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’,)

3 Replies 3

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?