Pass/Fail status based on value of one cell being less than or greater than another cell

Hi All,

Would appreciate some guidance on a formula I'm having trouble with. I would like to create a pass/fail column based on whether the value in a column@row is greater than or less than the value of another column@ row.

Current Formula - =IF(CFUs@row > [Action Level CFU]@row, "Fail", "Pass")

For some reason, I am still getting a "Fail" result when the CFUs@row value is less than the [Action Level CFU]@row value. Please see the highlighted below.


Appreciate the help.

-Peter

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!