Sharepoint Server 2019 multiple validation in survey

Viewed 12

I am using valid in my Sharepoint Server 2019 survey:

=LEN([Field1])>=6

It force a single line text field to have at least 6 digits But I need to add OR statement. I need to allow this field to have either 6 digits + or value "-" to pass. Logic behind this is that people can either write a text in this field or leave it blank. But I need them to write "-" by themselves cause otherwise they will make a lot mistakes by leaving blank fields. I need fail proof solution.

I tried multiple OR solutions but it all failed :(

Thank you!

0 Answers
Related