What is wrong with my formula?!?

brianw

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!

Andrée Starå

Hi @brianw

I hope you're well and safe!

Try something like this.

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

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @brianw

I hope you're well and safe!

Try something like this.

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

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

brianw

Thank you that worked. So the " were my problem?

Andrée Starå

@brianw

Excellent!

You're more than welcome!

Yes, the issue was the "" because when you put them around numbers, Smartsheet reads it as text instead of numbers.