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?


  • Bassam Khalil
    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.

    PMP Certified


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!