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?
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!