Filtering a view with a comma separated list of company IDs

[seliMiles]

Is it possible to create either an active list, or a company view where Company ID = multiple IDs? E.g. Company ID is one of Company ID1, Company ID2, Company ID3

The only way I've been able to do this so far is to create a list with multiple OR statements for Company ID, and then create a Company view for companies that are list members of this list....but this isn't scalable:

I have tried importing a single column CSV of Company IDs in the hopes I could then use that as a static list, and then create a company view where the company is a list member of that uploaded list. However the single column upload file fails.

If anyone has any info to share that would be great.

[karstenkoehler · Accepted solution]

Hi @seliMiles,

You should be able to copy multiple values at once by putting them in one column and filling a second column with semicolons, as shown in the screenshot below:

When you select and copy A1:B4, then paste it into the 'is equal to any of' field in HubSpot, the system should recognize separate values.

Hope this helps!

[seliMiles]

Thanks for the response. For whatever reason I can't get HubSpot to accept it...