Building an If/Than for a Pass Fail Based on a Cell Value
I work in a shoe factory in quality control and am currently using smartsheet to enter via form our test results for bonding strength for sole adhesion tests we do in our lab. I am trying to create a statement formula in which If the cell value is Greater than or equal to 80, it is a pass, less than it's a fail. That is an easy formula, no issue getting that to work. After I put it into place, I realized that sometimes, i'm only getting one sample (only one right shoe, no left or vice versa), so i can't base it off of both columns, the logic would have to be based on if i have entries for that value or not. If that makes sense....
Here's some pictures to help put it into place in a test sheet that i have:
Primary column is where I have my basic formula of =IF(AND([Column2]@row >= 80, [Column3]@row >= 80), "PASS", "FAIL").
Column 2 is an average of an array of cells where operators enter in their result for the left sample.
Column 3 is an average of an array of cells where operators enter in their result for the right sample.
Row 2 in this test has a value of zero for column 2 as we only received one sample, but the value in column 3 passes.
Is there a way to set up a formula so that when column2 equals 0, it only takes into account column3's data?
Help Article Resources
Check out the Formula Handbook template!