Linking multiple columns to a different sheet under one column?

rtahtinen

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å

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!

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!

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.

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

Cheers,

Genevieve