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?
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)
Without knowing the formulas (maybe there are problems in them) I can only suggest to put them in brackets. Following your example, it should be:
=(formula 1) AND (formula 2)