# What is wrong with my formula?!?

✭✭✭
edited 12/02/21

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!

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭

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

• ✭✭✭✭✭✭

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.

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!