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?