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 Collection of Texts.

collectionContains example

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

The formula returns the Boolean value True.