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

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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.