# "Contains" formula function

**URL:** <https://community.fibery.io/t/contains-formula-function/10178>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [December 16, 2025, 7:27pm UTC](https://community.fibery.io/t/contains-formula-function/10178 "2025-12-16T19:27:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [December 16, 2025, 7:27pm UTC](https://community.fibery.io/t/contains-formula-function/10178/1 "2025-12-16T19:27:20Z")

</div>

For comparing strings, as well as comparing a collection and a single entity. Does entity x exist in collection y.

Possible with the workaround “Find()” function, but a lot less clean.

---

<div class="post-metadata">

**Author:** ![Kendall\_Zhu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/kendall_zhu/32/13552_2.png) [@Kendall\_Zhu](https://community.fibery.io/u/Kendall_Zhu)\
**Post date:** [December 27, 2025, 6:16pm UTC](https://community.fibery.io/t/contains-formula-function/10178/2 "2025-12-27T18:16:57Z")

</div>

It would be useful to be able to check if an item is a member of a collection, when filtering in a formula. Right now the best workaround seems to be to convert the collection to a concatenated string elsewhere (since you can’t call join inside a filter), and check for regex string match on name. This would not be robust to names containing other names, and is more roundabout than it would be if you could check for collection membership.

Somewhat related to this as well, for ways to use collections in formulas: ["Union" function to merge multiple collections into a single collections field](https://community.fibery.io/t/union-function-to-merge-multiple-collections-into-a-single-collections-field/5680)

---

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [December 27, 2025, 7:21pm UTC](https://community.fibery.io/t/contains-formula-function/10178/3 "2025-12-27T19:21:00Z")

</div>

I have this need too! I made a request here, I think it’s the same: ["Contains" formula function](https://community.fibery.io/t/contains-formula-function/10178)

> [@Kendall\_Zhu](#):
>
> check for regex string match on name. This would not be robust to names containing other names,

BTW, you can check the Public ID, it’s more robust than name. I usually make a formula on the entity “Public ID Code”: “{” + [Public ID] + “}”

Then join based on this formula on the entity that has the collection, then run the “contains” check (I usually use Find() instead of regex, but I think either works.)

---

<div class="post-metadata">

**Author:** ![Kendall\_Zhu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/kendall_zhu/32/13552_2.png) [@Kendall\_Zhu](https://community.fibery.io/u/Kendall_Zhu)\
**Post date:** [December 27, 2025, 7:35pm UTC](https://community.fibery.io/t/contains-formula-function/10178/4 "2025-12-27T19:35:42Z")

</div>

Thanks for the tip! Upvoted your request

---

<div class="post-metadata">

**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\
**Post date:** [September 8, 2026, 5:25pm UTC](https://community.fibery.io/t/contains-formula-function/10178/5 "2026-09-08T17:25:07Z")

</div>

In need of this again…

The solution i suggest above breaks if the text field has more than 1000 characters.