User Profile
blabla70
Copper Contributor
Joined Sep 21, 2023
User Widgets
Recent Discussions
column validation doesn't work correctly
Hi, I have two relational SP lists. In the source list I need one new column with yes or no values. I realized that this cannot be the "Yes/No (check box)" column type, because it is not accepted when connecting with the target list (via lookup). So I use the "single line of text" column type - where I apply the "column validation" because I want it to accept only "y" and "n" values, but my formula doesn't work correctly. I tried with following formulas: =OR(UPPER(Read)="Y",UPPER(Read)="N") =IF(LEFT([Read],1)="y",TRUE,FALSE) =IF(LEFT(Read,1)="y",TRUE,FALSE) The wrong input doesn't get accepted, which is fine. But, instead of getting the custom warning message, the sync fails (as in attached img) My question would be how to fix it and get the warning message while editing or adding a new line? Any other suggestions? Thanks in advance!
