Forum Discussion
Sharepoint Server 2019 double validation (minimum amount of characters or certain character in field
It shows that I cannot refer to different column but I am reffering to the same.
Column name is (a survey question):
"II. Programming for IT Business"
Column name in URL at edit page:
"II_x002e__x0020_Programming_x0"
I am using it like that:
=OR([II_x002e__x0020_Programming_x0] = "-";LEN([II_x002e__x0020_Programming_x0])>=6)
=OR([II. Programming for IT Business] = "-";LEN([II. Programming for IT Business])>=6)Am I doing something wrong?
When I try to do this from validation menu (not in a question but general menu) it shows that I refer to not existent column....
F0RCE I just tried it on my SharePoint site and it works fine for me. Formula used:
=OR([II. Programming for IT Business]="-",LEN([II. Programming for IT Business])>=6)
Column settings:
Output:
Try using correct and exact display name of column. Make sure you are using spaces correctly also check case sensitivity (capital/small letters) of column name.
Did you also try using comma instead of semicolon? Or your site works with semicolons only?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
This question is a single line of text.
When I am using , it shows syntax error.
When I am using ; it shows that I am reffering to the different column. I check many times, I even renamed field question to 1 and it still showed that I am reffering to different column.
Maybe for my Sharepoint version I also need to refer column in a different way - since I cannot use , maybe I should not use [ ]... I do not know.
trying to see syntax changes between different language versions but cannot find anything
F0RCE I just tried again on another SharePoint site where semicolon works instead of comma and it worked for me without any issue.
Here's the formula I used (same for given by you in above comments):
=OR([II. Programming for IT Business] = "-";LEN([II. Programming for IT Business])>=6)Column settings:
Are there multiple spaces between words in your column name?
Can you try creating another survey list in same SharePoint site and see if issue can be replicated there?
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- I just noticed that it works great in a different survey!
It just doesn't work in a survey that was made from a template with data. Is it bug?