I am struggling to add two formula together in SharePoint list column validation.
For example :
= formula 1 AND formula 2 (didn't work) ; = formula1,formula2(didn't work)
Can anybody give some light?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
It has to be in below format for logical operations AND and OR
Column 1 - 15 Column 2 - 9 Column 3 - 8
=AND([Column1]>[Column2], [Column1]<[Column3]) - Is 15 greater than 9 and less than 8? Value -(No) =IF(AND([Column1]>[Column2], [Column1]<[Column3]), "OK", "Not OK") - If 15 is greater than 9 and less than 8, return "OK". Value - (Not OK)