can you write a saved search formula to see if a text field is contained in a list of values for example "111-222" is in ("111-222", "222-333")

AI generated answer (using internal Slack threads):

Based on the conversations, you can use a formula in a saved search to check if a text field is contained in a list of values. Here's an example of how you can do it:

CASE WHEN {yourfield} IN ('111-222', '222-333') THEN 'Yes' ELSE 'No' END

In this formula, replace

{yourfield}

with the actual field you want to check. The formula will return 'Yes' if the value of

{yourfield}

is either '111-222' or '222-333'. Otherwise, it will return 'No'. If you want to check if the value of a field is contained in a multiple select field, you can use the

INSTR

function. Here's an example:

CASE WHEN INSTR({multi-select field}, {yourfield}, 1) > 0 THEN 1 ELSE 0 END

In this formula, replace

{multi-select field}

with the actual multiple select field and

{yourfield}

with the actual field you want to check. The formula will return 1 if the value of

{yourfield}

is contained in

{multi-select field}

. Otherwise, it will return 0. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******