formula for multiple if/or

I would like to create a formula to do the following based another field:

  • If the field is blank, leave this field blank.
  • If the field is greater than 22 or less than 18, the field should read "fail".
  • If the field is between 18 and 22, the field should read "pass".

I tried this:

=IF(ISBLANK([Strap dimensions - strap 3]@row), "", IF(OR([Strap dimensions - strap 2]@row > 36, [Strap dimensions - strap 2]@row < 32), "Fail", "Pass"))

It seems to work for the blank condition and the fail condition, but not the pass condition. Any suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!