Trying to consolidate specific rows from multiple sheets into one
Hi,
I currently have 11 project plans and I would like to consolidate specific rows (e.g., rows related to a specific system) within those plans to a master plan, where I would add additional columns to edit. I looked into reports and linking cells, but these don't seem to do what I need. The consolidated report should be able to bring in new rows from the project plans that are are related to the specific system. Example image below. Please let me know any options
Answers
-
You'll want to use reports. Unfortunately you'll need to also add in the additional columns into each of your sheets and then hide them if you only want them to show up in the report. The other thing that reports are lacking is the ability to add new rows which you can solve by creating a blank project sheet and including those in your report. Then creating an automation in the blank project sheet to copy the information to the sheet the info is intended to go to followed by clearing the values so they can be used again. Hope this helps.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives