Document Builder with multiple rows of data
Is generating a document with data from multiple rows possible?
For example, I have a sheet that has:
Columns: Team Name / Team Lead / Phone Number
Row 1: Alpha Team / John Doe / 555-555-5555
Row 2: Bravo Team / Jane Doe / 666-666-6666
Row 3: Charlie Team / Joe Doe / 777-777-7777
I would need to generate a document with all the info for Team 1, Team 2, and Team 3. As far as I know, documents are generated for one row only. I need one single document, not three individual documents. Any information will be greatly appreciated.
Answers
-
Hi @RDRGSJ00,
a workaround idea, try to make 9 columns for Team Name / Team Lead / Phone Number and change the names of those columns to Team Name1 / Team Lead1 / Phone Number1, Team Name2 / Team Lead2 / Phone Number2, Team Name3 / Team Lead3 / Phone Number3 then generate your document.
bassam.khalil2009@gmail.com
☑️ 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 @Bassam Khalil , that would work except the real data I'm working with has 10 teams, each with 10 columns of information. That's going to be a lot of columns. I'm wondering if there is another workaround that won't require 100 columns.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives