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

Find more posts tagged with

Formulas

Accepted answers

Heather Duff

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

All comments

Heather Duff

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

Lauren Ford

Hi Heather,

This was exactly what I was looking for. Thank you so much!!!

Lauren

Heather Duff

Happy to help! :)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.