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 re...
Hi! My formula to flag an older blog post as in need of an update isn’t working and I’m not sure why. Here’s the formula:
IF(DATETIME_DIFF({Date Last Updated},TODAY(), ‘months’) > 12, “Update”, " ")
The logic I want is this:
If more than 12 months ha...
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.”
