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.