Linking multiple columns to a different sheet under one column?

I am working on taking one of my sheets that have multiple columns of floor care/cleaning projects that need to be done from a form that was inputted in, and creating a master sheet that puts all the projects under 1 column? Is there a formula that you would suggest to read multiple columns that are not blank from one smartsheet to another?


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @rtahtinen

    I hope you're well and safe!

    Not sure I follow! Can you elaborate?

    Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    Be safe, and have a fantastic weekend!


    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!


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • rtahtinen
    rtahtinen ✭✭✭✭

    sorry I did not get back with you sooner it got a little crazy. Here is a snip of what I am talking about.

    I have a "Form" that my managers fill out that automatically is put on this spreadsheet. There are multiple columns that deal with floor care "Location" "Type" "Needs" and what I am trying to do is create another sheet that can just pull from those columns that are NOT blank so we can assign them to be completed as a project. Is that possible?

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @rtahtinen

    If I'm understanding you correctly, you'd like to have each of these columns merge into one column on a different sheet, with each selection in its own cell but in the same column, is that correct? So in your image, each of the multi-select values in the third column would be parsed out into individual rows?

    At this time there isn't a way to do this, where the values are parsed out into separate rows from multiple columns / multi-select cells.

    What I would suggest doing instead is to set up a Report that only brings in the three columns you want to look at (and perhaps one other column for comments). Even though the cells will be three-in-a-row, this should help visualize all the tasks needing to be completed! See: Build a row report and SmartStart: Reporting



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!