Skip to main content

And is there a character limit for each value?

 

I'm trying to create a List View that contains Leads from 113 specific companies. When I filter by "Company contains Company1,Company2,Company3,etc" I get the error message "Filter value is invalid." I tested filtering different sized lists, removing certain companies, and cannot seem to find a pattern for when the error message appears.

 

#List Views #Salesforce #Sales And Marketing #Email Marketing

5 answers
  1. Aug 24, 2021, 3:53 PM

    Hi Juliana, 

     

    I'm not sure if this is resolved, but I wanted to offer a different approach to the issue. Instead of filtering on contains specific account names, why don't you filter on something unique to those 113 accounts? 

     

    If you don't have anything unique now, create a new field that you can use with either a true/false check, picklist, or whatever works best for you. I use a "Sales Initiative" picklist field to narrow our reports with a "Top Target" selection that I can quickly filter on. I've got other selections in there as well to manipulate account reports easily. Adding the new field will do two things for you.

     

    1) You can filter on this specific field and don't have to worry about the character limitations that you are running into.

    2) It makes it easier to add or remove accounts from the list view. If you needed to remove a couple of accounts, you would need to retype your filters or search for the specific accounts in the filter to remove them. Using the new field you can easily add or remove accounts from the list based on the selection.

0/9000