Need to convert excel list to a multi-select in Smartsheet
When I imported data from Excel there were values in a list that look like this in the field: (NOT AVAILABLE); GLOBAL MARKETING ORGANIZATION; MARKETING & CONSUMER OPS - VIDEO/BB
How do I make each of these values a multi-select value so we can easily run reports without manually updating each one?
So the list in Smartsheet would have the following as values:
GLOBAL MARKETING ORGANIZATION
MARKETING & CONSUMER OPS - VIDEO/BB
There are more values so this is just a subset as an example
Help Article Resources
Check out the Formula Handbook template!