What is wrong with my formula?!?

brianw ✭✭✭
edited 12/02/21 in Formulas and Functions

Hi all

I am using the following formula to tell me if a certain selection is made and another entry is greater than or equal to 12, but for some reason it is still flagging as Yes even when the cell is less than 12. What am I doing wrong?

=IF(AND([12 Hour Notification]@row >= "1", [Estimated Duration of Fire System Work]@row >= "12"), "Yes", "No")

I am using helper columns to tell me if a selection is present in the multi-select cell.

Edit: the formula appears to work until your numbers are 10 or greater then it get its wrong for some reason. If I change it to less than or equal to a number 10 or greater it will give the correct answer.

Thanks for the help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!