SharePoint List Validation Settings gives me Syntax error

Question

=IF([Urgency Level] = "XL", IF(ISBLANK([Date and Time of Production Stop just in case of XL]),false,true),true)

I get a syntax error message with this formula.

It tells me either the formula doesn't exist anymore or I got a syntax error inside the formula.

Do you guys see what I am doing wrong? This would help me a lot.

Where are you adding this formula? Display name of date column is correct? — Ganesh Sanap - MVP, Commented Aug 13, 2022 at 3:00
Yes, the display name is correct. I go to list settings -> validation settings. Thats where i put this formula. But i feel like i get this error message for everything i put in there. — Rambo, Commented Aug 16, 2022 at 8:07
i want "Date and Time of Production Stop just in case of XL" to be a required field, if Urgency Level is set on "XL". — Rambo, Commented Aug 16, 2022 at 8:08

Ganesh Sanap - MVP · Accepted Answer · 2022-08-16 09:06:41Z

0

Try using this formula:

=IF([Urgency Level]="XL",IF(ISBLANK([Date and Time of Production Stop just in case of XL]),FALSE,TRUE),TRUE)

OR

=IF([Urgency Level]="XL",NOT(ISBLANK([Date and Time of Production Stop just in case of XL])),TRUE)

Note:

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
Make sure you are using correct display names of your columns (case-sensitivity, etc).

Official Documentations:

answered Aug 16, 2022 at 9:06

46.4k22 gold badges31 silver badges63 bronze badges

These don't work either. The sharepoint language is german. Does that mean i have to type the german function names instead maybe? Because if i click on the help me link on ther validation setting site, i get all the function names in german. For example "WENN" instead of "IF". I tried it in german aswell but didn't manage to solve this. Could it maybe be the case that i don't have enough permissions to change the list validation settings?
– Rambo
Commented Aug 16, 2022 at 13:47
Do i need the display names of the columns here or the internal names? These above are the display names
– Rambo
Commented Aug 16, 2022 at 13:52
You should have at least "Edit" or higher (Design/Full Control) permissions on list. Did you try using semicolon in formula like: =IF([Urgency Level]="XL";NOT(ISBLANK([Date and Time of Production Stop just in case of XL]));TRUE).
– Ganesh Sanap - MVP
Commented Aug 16, 2022 at 14:13
In formula, you have to use the display name of the columns.
– Ganesh Sanap - MVP
Commented Aug 16, 2022 at 14:14
1

This actually worked. Thank you a lot! I guess have to use semicolon all the time.
– Rambo
Commented Aug 16, 2022 at 14:26

Add a comment |

1 Answer 1