Trying to combine 2 AND functions with an OR
I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble.
Basically, I am trying to check a box in a column if any of the following is true.
If the Model type is 1 AND the version is less than 9
If the model is 2 AND the version is less that 18
Below is what I have been trying. The result here is if the model is 1 and less than 9 the box is checked but if the model is 2 the box never gets checked no matter what value is entered. My formula seems to be ignoring the 2nd set of parameters.
=IF(AND([MODEL]@row = 1), AND([VERSION]@row < 9), OR(AND([MODEL]@row = 2, AND([VERSION]@row < 18), true, false)))
Help Article Resources
Check out the Formula Handbook template!