IF formula when multiple options are selected
Hello!
I'm trying to see whether or not there's a way to create an IF formula based on one of several options select in a multi-select pick list. One of the fields that my current IF formula is based on has a multi-select pick list. If users select multiple options within that pick list, the formula doesn't formulate.
The column highlighted in yellow above, is the multi-select column.
I just need for the formula work if "Yes, Approved" is one of any options selected in the pick list. Not if "Yes, Approved" is the only option (which is how it is currently working).
Is this possible? Any insights would be greatly appreciated.
Thanks!
Lauren
Best Answer
-
Hi @Lauren Ford ,
Have you heard of the HAS function? It has the capability of counting selections in a multi-select dropdown.
Your formula could look something like this:
=IF(HAS([Approved for Food Grant (Yes/No)]@row,"Yes, Approved for Food Grant"),([Amount Allocated per Month]@row * [Number of Months Awarded (4 max)]@row))
Hope this helps! Let me know if it works.
Best,
Heather
Answers
-
Hi @Lauren Ford ,
Have you heard of the HAS function? It has the capability of counting selections in a multi-select dropdown.
Your formula could look something like this:
=IF(HAS([Approved for Food Grant (Yes/No)]@row,"Yes, Approved for Food Grant"),([Amount Allocated per Month]@row * [Number of Months Awarded (4 max)]@row))
Hope this helps! Let me know if it works.
Best,
Heather
-
Hi Heather,
This was exactly what I was looking for. Thank you so much!!!
Lauren
-
Happy to help! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!