Hey Ron. I believe you should be able to copy a list, separated by semicolons, should work, yes. If it's all in a spreadsheet, you should be able to find + replace commas with semicolons. Hopefully that makes a little easier.
Did my answer help? Please "mark as a solution" to help others find answers. Plus I really appreciate it!
@Benvenisti if you create a list for regions based on ZIP codes, and included all values there, you could create a wrokflow that looks at list membership instead of individual ZIP codes. It's still going to be a bit of a lift, as there isn't a choice or ZIP code ranges, but you could certainly build a filter of multiple codes. That would be my first route.
Did my answer help? Please "mark as a solution" to help others find answers. Plus I really appreciate it!
I'm looking into the solution you proposed and I have one question.
while creating the list based on the filter - ZIP code is equal to any of ..., is it possible to copy paste into the value field all the ZIP codes for a specific sales person?
each sales man may have hundreds of ZIP codes and there are over 30 sales people so inserting each code separately is quite impossible.
Hey Ron. I believe you should be able to copy a list, separated by semicolons, should work, yes. If it's all in a spreadsheet, you should be able to find + replace commas with semicolons. Hopefully that makes a little easier.
Did my answer help? Please "mark as a solution" to help others find answers. Plus I really appreciate it!