Which function allows filtering of a table based on whether a text contains a specific substring?

The function that allows filtering of a table based on whether text contains a specific substring is indeed the "Contains" function. This function is specifically designed to check if a given substring exists within a larger string of text. In practical applications, such as searching through database records, "Contains" can return a boolean value—true or false—indicating whether the specified text is found.

Using the "Contains" function enables users to streamline data retrieval by filtering only the entries that meet the substring criteria. This is particularly useful for tasks like searching for keywords or tags within large datasets, as it efficiently narrows down results to those that are relevant to the user's query.

In contrast, while the "FIND" function can also locate substrings within text, it does not filter data by itself; rather, it returns the position of the substring if found, which isn't directly suitable for filtering in tables. The "SUM" function, on the other hand, is used for adding numerical values and has no relation to text filtering. Lastly, "TEXTFILTER" is not a standard function recognized for filtering text specifically using a substring criterion, making it less relevant in this context. Therefore, "Contains" is the optimal choice for filtering based on text inclusion.