Working on a SharePoint list with a calculated column with a date, which I want to make dependent on priority (column is called Prioriteit
), and date of creation (Datum melding
).
I made this formula in Excel first (this worked):
=IF(B4="Hoog";A4+30;IF(B4="Midden";A4+60;IF(B4="Laag";A4+90)))
Then I tried translating it for SharePoint:
=IF([Prioriteit]="Hoog";[Datum melding]+30;ALS([Prioriteit]="Midden";[Datum melding]+60;ALS([Prioriteit="Laag";[Datum melding]+90)))
It didn't work. The error I'm getting is"
The formula contains a syntax error or is not supported.
I tried simpler equations with IF function like:
=IF([Prioriteit]="Hoog";[Datum melding]+30;10)
I tried replacing semicolons with commas, I tried replacing IF with ALS (conforming to my own language, tried deleting the =
at the beginning.
Any idea what I'm doing wrong?
=IF([Prioriteit]="Hoog";true;false)
. If this does not work, try replacing;
with,
– Ganesh Sanap May 28 '20 at 10:33Prioriteit
and not the internal name of field. – Ganesh Sanap May 28 '20 at 11:09