Export as XLS with multi-select answers in different columns?

I want to export a sheet into XLS. I want all my columns that are multi-select to export as separate columns.

For example, instead of one column "What kinds of animals do you like" and all selected answers appear in the subsequent cells, I want three columns "Cats," "Dogs," and "Rabbits" and a Y/N indicator in the subsequent cells.

Is it possible to do this automatically?

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @katelyndurkin

Exporting a sheet from Smartsheet into Excel while transforming multi-select columns into separate columns for each option, with a Y/N indicator for selection, this specific functionality isn't directly supported by Smartsheet's export feature.

you need to create helper columns in your original sheet or in new sheet and use formula to subtract each value from the columns which contains the muti select answers.

katelyndurkin

Thank you! How do I subtract the values from the original column?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.