How to List New Options From A Multi-Choice Column As a Value In Another Sheet?

danilo

Hey Guys,

I've been trying to find a solution but I'm stuck.

I have a 'master' sheet that has a multi-choice column for countries of operations for some partners. The choices will increase over time as my partners increase their countries of operations. I am trying to create a formula that will use this column as a reference and automatically list the countries in another sheet with the newly added countries, and in addition count all the countries without duplication

Column:

Row 1: Spain, France

Row 2: Brazil, Spain, France

Row 3: France, Chile

Desired Result in Another Sheet:

Row 1: Spain

Row 2: France

Row 3: Brazil

Row 4: Chile

Total Countries: 4

I know that I can manually update another sheet by just adding new countries but I want for my 'master' sheet to be the source of truth for other sheets in my folder.

Any thoughts?

Andrée Starå

Hi @danilo

I hope you're well and safe!

A solution that would be perfect for this use-case is the premium add-on, Data Shuttle.

Is that an option?

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-uploader

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

danilo

Thanks Andree! I will research that app and see if it could be a solution.

Andrée Starå

@danilo

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!