Jul 12 2021 05:14 AM
Hi!
Below is my full if formula, for now Im just testing this one:
=IF([HOTEL]="CVS - Centralværkstedet","info@t.dk","Test")
Pretty basic, but it is not working.
Error message:
" Sorry, something went wrong
The formula contains a syntax error or is not supported."
=IF([HOTEL]="CVS - Centralværkstedet","info@t.dk",
IF([HOTEL]="CBO - Borupgaard","info@t.dk",
IF([HOTEL]="CCP - Copenhagen Portside","info@t.dk",
IF([HOTEL]="CHC - HC Andersen Odense","info@t.dk",
IF([HOTEL]="CHO - Holte","info@t.dk",
IF([HOTEL]="CAL - Hvide Hus Aalborg","info@t.dk",
IF([HOTEL]="CKP - Kellers Park","info@t.dk",
IF([HOTEL]="CKL - Klarskovgaard","info@t.dk",
IF([HOTEL]="CKO - Kolding","info@t.dk",
IF([HOTEL]="CKG - Kongerbrogaarden","info@t.dk",
IF([HOTEL]="CKS - Køge Strand","info@t.dk",
IF([HOTEL]="CMI - Middelfart","info@t.dk",
IF([HOTEL]="CRE - Rebild Bakker","info@t.dkm",
IF([HOTEL]="CRO - Roskilde","info@t.dk",
IF([HOTEL]="CSO - Sorø","info@t.dk",
IF([HOTEL]="CAA - Aarhus","info@t.dk"))))))))))))))))
Jul 12 2021 06:38 AM - edited Jul 12 2021 07:09 AM
I think you simply nested too many IFs. Isn't 7 the maximum?
What kind of column is [HOTEL] ? Text, Choice, Lookup?
Jul 12 2021 06:54 AM - edited Jul 12 2021 07:06 AM
While I couldn't figure out the exact issue, I received the same error when I copy/paste your test formula. I erased it and started building it one element at a time. I started with
=IF([HOTEL]="","1","2")
and substitute one string at a time, testing between each change. I ended up with
=IF([HOTEL]="CVS - Centralværkstedet","info@t.dk","Test")
which works. It looks the same, but something is different. (I suspect a hidden invalid character.) Just keep building the formula piece by piece. It's slow and frustrating sometimes, but without a better error message from SharePoint, there is not much else you can do. It will either work, or you will find the exact change that is causing the issue.
If this helps, please consider marking it as the solution. Thanks and good luck!
Don
Jul 12 2021 06:58 AM
Jul 12 2021 07:05 AM
Jul 12 2021 07:08 AM
Jul 12 2021 08:02 AM
Jul 12 2021 11:39 AM