What is wrong with my formula?!?
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
-
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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!