Filtering a view with a comma separated list of company IDs

SOLVE
seliMiles
Member

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:

seliMiles_0-1603475704322.png

 

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.

0 Upvotes
1 Accepted solution

Accepted Solutions
karstenkoehler
Solution
Thought Leader | Partner

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:

 

copy.png

 

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!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Hat mein Beitrag deine Frage beantwortet? Bitte hilf der Community und markiere ihn als Lösung.

View solution in original post

2 Replies 2
karstenkoehler
Solution
Thought Leader | Partner

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:

 

copy.png

 

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!

Karsten Köhler
Freelance Digital Marketing Advisor

Beratungstermin mit Karsten vereinbaren


Hat mein Beitrag deine Frage beantwortet? Bitte hilf der Community und markiere ihn als Lösung.

View solution in original post

seliMiles
Member

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

 

multiselect.gif

0 Upvotes