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 (
I made this formula in Excel first (this worked):
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:
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?