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. | Community
Skip to main content
Level 2
July 6, 2021
Question

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.

  • July 6, 2021
  • 1 reply
  • 498 views

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")

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Level 2
October 20, 2021

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!