
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 10, 2021 12:08 AM
Hi there,
Hope you’re doing well !
Can someone help me to formula-translate “has none of” please ? :slightly_smiling_face:
What i need to do is to make a webhook call to filter some results and only take the ones which does not contains “SFR or Orange” in “which_network”.
Thanks a lot

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 10, 2021 06:39 AM
OR(FIND("SFR", ARRAYJOIN({which_network})), FIND("Orange", ARRAYJOIN({which_network})))
This will return 1 if either of the two terms appear in the multi-select field, and otherwise returns 0. This will let you duplicate the “has none of” behavior.
To set it up so that it will also return 1 if the field is empty, use:
IF({which_network}, OR(FIND("SFR", ARRAYJOIN({which_network})), FIND("Orange", ARRAYJOIN({which_network}))), 1)
That will allow you to filter to only get items that have some selection other than “Orange” or “SFR”. This is not quite the same as the “has none of” filter, but it might be useful for your purposes.
