Hi Lui! Question for you on column validation for multiple conditions. Say you want the first two letters of the data to either be "XX" or YY" . Can that be accomplished in a similar way as you have in your example at 17:13 - SharePoint column validation multiple conditions? Thanks in advance :)
Hello, my apologies for the delay in responding to your comment. I hope that you found an answer by now. Yes, you should be able to accomplish this using the same approach outlined at the specified part of the video. It might become a bit messy though as you’ll need to use the LEFT formulas as well (I have a video outlining how to use this here: th-cam.com/video/X7cU0aDiEso/w-d-xo.html). If you are having trouble, another suggestion might be to create and hide a calculated column that extracts the first two letters and then you can simply reference that in your column validation. Hope this helps!
Hey @LuiIacobellis - not sure if you will see this. I am trying to just validate an email address - meaning I just want to make sure the email address has the @ sign. I have been trying to find a validation formula to use for this. I can't find one. Is there anyway to validate that a column CONTAINS a particular string (in this case the @ sign) and then either accept it for saving or error? I can't believe it is this difficult to find this out. Crazy! I've been searching the microsoft help as well as youtube. Thanks!
Hello Lui, is there any way where you can add a column validation that checks if a column contains a backslash (\) character or not? The thing is that we use the following values for a specific column: [domain]\[user ID] (for example US\ABC123). I want to make sure that the domain and the backslash is entered (US\) and not only the user ID (ABC123). The thing is that the domain varies between 2-4 letters and the user ID is not always the same amount of letters either. Do you have any suggestions on how to best do a column validation in this case?
CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: th-cam.com/play/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh.html
Hi Lui! Question for you on column validation for multiple conditions. Say you want the first two letters of the data to either be "XX" or YY" . Can that be accomplished in a similar way as you have in your example at 17:13 - SharePoint column validation multiple conditions? Thanks in advance :)
Hello, my apologies for the delay in responding to your comment. I hope that you found an answer by now. Yes, you should be able to accomplish this using the same approach outlined at the specified part of the video. It might become a bit messy though as you’ll need to use the LEFT formulas as well (I have a video outlining how to use this here: th-cam.com/video/X7cU0aDiEso/w-d-xo.html). If you are having trouble, another suggestion might be to create and hide a calculated column that extracts the first two letters and then you can simply reference that in your column validation. Hope this helps!
is it possible to use regex to validate email and phonenumbers ?
Great explanation
Thank you for the comment and for watching!
Hey @LuiIacobellis - not sure if you will see this. I am trying to just validate an email address - meaning I just want to make sure the email address has the @ sign. I have been trying to find a validation formula to use for this. I can't find one. Is there anyway to validate that a column CONTAINS a particular string (in this case the @ sign) and then either accept it for saving or error? I can't believe it is this difficult to find this out. Crazy! I've been searching the microsoft help as well as youtube. Thanks!
Hello Lui, is there any way where you can add a column validation that checks if a column contains a backslash (\) character or not? The thing is that we use the following values for a specific column: [domain]\[user ID] (for example US\ABC123). I want to make sure that the domain and the backslash is entered (US\) and not only the user ID (ABC123). The thing is that the domain varies between 2-4 letters and the user ID is not always the same amount of letters either. Do you have any suggestions on how to best do a column validation in this case?
The solution seems to be: =AND(FIND("\",[ColumnName])>=3,FIND("\",[ColumnName])
life saver thank you
sarcastiXperimental You're very welcome! Thanks for watching!