Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 04, 2021 12:27 PM
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’,)
Feb 05, 2021 03:37 AM
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.
Feb 08, 2021 02:22 PM
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.”
Feb 09, 2021 12:50 AM
Can you post the formula you’re using and a screenshot of your table?