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.
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
99,9% servers uptime
No usage restrictions
Perfect for SEO
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!