IF formula with DATEADD as a condition - cannot get this to work

Formulas
1

Hello,

I am trying to create an IF formula containing this;

DATEADD({REVIEWED ON}, 1, ‘year’)

So it would read;

IF({REVIEW NEEDED?}=“Yes”,(DATEADD({REVIEWED ON}, 1, “year”)),“”)

However, it’s simply not working - clicking SAVE FIELD and it’s not accepting it.

The field REVIEW NEEDED? is itself a formula field, with outputs of either Yes or No (as text).

What am I missing here please?

Thanks,

Ian

2

This works. If you are copy pasting formula, sometimes the quotes used are incorrect one’s. I would recommend to remove quotes in the formula and type again.

IF(({REVIEW NEEDED?} == "Yes"), DATEADD({REVIEWED ON}, 1, "year"), "")
2 Likes
3

I actually managed it with this;

SWITCH({REVIEW NEEDED?}, “Yes”, (DATEADD({REVIEWED ON}, 1, ‘year’)), “”)

Worked perfectly!

1 Like