Need to create a calculated field that looks for the presence of an item not in a list (even if other named values are selected). The field will be used to create a view that presents items that have the ‘Specify your own value’ field within the selections from a multi-value choice column. I have created a Nintex workflow that takes all of the selections from the choice column and copies them into a text field so that it can be used within a calculated field.
My issue is creating a calculated field formula that will equate to 1 if a ‘Specify your own value’ entry has been made either alone or with other named selection values. I’ve tried several versions that do not work using a combination of ISNA and FIND text but they seem to only find items where no or all named items have been selected…for example, this doesn’t quite work:
=IF(OR(ISNA(FIND(“Selection 1”,TopicFilterText)),ISNA(FIND(“Selection 2”,TopicFilterText)),ISNA(FIND(“Selection 3”,TopicFilterText)),0,1)
where ‘TopicFilterText’ is the value of the field where the workflow has copied all of the selected values (or write-in value) as a string of text. (e.g. Selection 1,Selection 2,Selection 3,[Write-in Selection])
Appreciate any help you can give.
Thanks,
Lawrence