+ Start a Discussion

Process builder Formula -Need Urgent Help

Iam having a query in Account 'SELECT Id,Name,outcome FROM Account WHERE Name LIKE 'Unable to Support%'' and this one we converted into process builder formula as 

NOT(CONTAINS(LOWER(TEXT([Case].Sub_Category__c), 'remove from field notices')))

Iam facing below error.

The formula expression is invalid: Incorrect number of parameters for function 'CONTAINS()'. Expected 2, received 1

Pls help me to fix this.


ShirishaShirisha (Salesforce Developers) 
Hi Isha,


If you would like to put the criteria same like the SOQL query then you can use the crieria as below:

Name Contains String 'Unable to Support%'' directly in the process builder.

But,not sure why you are trying to query the Case Object.

Even if you are trying to write the criteria on the "[Case].Sub_Category__c" field then also you can simply use the criteria as below:

NOT(CONTAINS([Case].Sub_Category__c, 'remove from field notices'))

The above formula should work.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Warm Regards,
Shirisha Pathuri

Hi Isha,

Try below formula:
NOT(CONTAINS(LOWER(TEXT([Case].Sub_Category__c)), 'remove from field notices'))
Hope this helps!