Forum Discussion
Error in Formula in List Validation Settings
- Oct 07, 2022
francescjp Make sure you are using correct display names of the columns in formula.
Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,) like:
=AND(LEN([Estat])>9;LEN([Title])>9)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.
francescjp Make sure you are using correct display names of the columns in formula.
Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,) like:
=AND(LEN([Estat])>9;LEN([Title])>9)
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.
- francescjpOct 10, 2022Brass Contributor
Hello ganeshsanap :
You are right. You have given a great solution. Thank you very much!!