Sheet control multi select warning using 'in' function

Question & Answer
, , , ,
1

Hi! I would like to create a calculated field using the in function to select multiple values from a parameter. This is how I have the parameter set up.

image
image785×919 35.2 KB

I wanted to create the following calculated field to see which users were served a campaign. But I get a “Sheet control multi select warning” error when the parameter is in the sheet
ifelse(in({campaign_name}, ${CAMPAIGNNAME}), {user_id}, NULL)
image
I have not created any parameterized calculations including campaign_id or send_time so I am unsure why this error is occurring. I get a different error when the parameter control is at the top of the page (screenshot below)
image
Any ideas why I am receiving these errors? Thanks in advance!

2

Hi @ryannschuessler,
Certain calculations do not work when dealing with single/multi select filters so the issue may be from the syntax may be incorrect.
What if you tried something like the following instead:

ifelse(contains(${CAMPAIGNNAME}, {campaign_name}), {user_id}, NULL)

1 Like
3

Hi @ryannschuessler,
Checking back in here as it’s been awhile since we last heard from you. Did you have any additional questions or were you able to find a work around for your solution?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

1 Like
4

Hi @ryannschuessler,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for any relevant information if needed.

Thank you!