Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Hello! I have a calculated field that looks to a multi-select field for it's calculation. It works great when the person only selects one value from the custom field, but does not work if someone selects multiple values.

Avatar

Level 3

It's okay if one of the multi-selects isn't on the list. As long as one of them is, it should show up as "CQR Brand in-scope."

In the instance that isn't working properly, the values "aetna" AND "cvs-health-hubs" were selected. Both should trigger the "CQR Brand in-scope"

Does IFIN not work with multiselect?

Here's the calculated field:

IFIN({How will your communication be branded?},"aetna","cvs-health-hubs","teladoc","aetna-medicaid","aetna-foundation","cvs-health","aetna-foundation","cvs-pharmacy","payflex","aetna-medicare-solutions","aetna-cvshealth","CQR Brand in-scope","CQR Brand out-of-scope")

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 3

Hi @Rachel Couvillon‚ , did you ever get this figured out? I'm having the same issue, and CONTAINS seems to have the same problem with multi-selected items. Thanks!