Lia_Garcia - profile

Lia_Garcia · Feb 04, 2021

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...

Lia_Garcia · Feb 03, 2021

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...

Lia_Garcia · Feb 08, 2021

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.”

Lia_Garcia · Feb 04, 2021

Worked like a charm! Thank you!

User Statistics

User Activity

If/And formula with date + text - help?

Trying to use "if" and "date difference" together

Re: If/And formula with date + text - help?

Re: Trying to use "if" and "date difference" together