You are here:
contains
Checks whether a string or list includes a specified value in Salesforce Spiff. This function returns true or false.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
Syntax
contains(string_or_list, search_value)Arguments
| Argument | Required? | Description |
|---|---|---|
| string_or_list | Required | The string, list of strings, or list of numbers that you're searching. |
| search_value | Required | The string or number you're searching for. Enclose string values in double quotes. |
Example
Turn a ClosedByRepInPeriod list into a list of items with the transform_list() function, and check whether the list includes the string "Widgets". To also check whether the function returns a value, enclose the function in an if() statement that returns 1 or 0.
=if(contains(transform_list(ClosedByRepInPeriod, Item__c), "Widgets") = true, 1, 0)This formula can help make sure that payouts aren't made if the statement period includes the word "widgets".
Did this article solve your issue?
Let us know so we can improve!
