User input text box to update multiple values within a "IN" formula.

[wonka1234]

Hi,

How can I format my values to update my IN formula to update my workflow?

[AngelosPachis]

Hi @wonka1234 ,

I think the change you should make for your updated formula to be applied in the filter tool is within the action tool.

Make sure to select the expression you want to update and when that is selected, check the checkbox at the bottom saying "Replace a specific string" and make sure that that string is whatever you have within the brackets of your IN function

[mceleavey]

@wonka1234 ,

alternatively to what @AngelosPachis suggested, you could cross-tab the values in the column you are trying to filter, so the values are the column headers, then feed these into a list box tool.

This will then allow you to select multiple values which will be dynamically populated from the values that are present. You can then simply check the boxes for the ones you want.

You can read more about the list box below:

https://help.alteryx.com/20213/designer/list-box-tool

Hope this helps,

M.