collectionContains

Use the collectionContains function to check if a Text value exists in the collection.

Function format

collectionContains(Collection of Texts, Text value)

• Collection of Texts: The collection of texts that is checked to find the Text value.
• Text value: The value that is searched for in the Collection source.

collectionContains example

collectionContains(["Newton Gold", "Carl Houston", "Melody Law"], "Melody Law")

The formula returns the Boolean value True.