add a source sheet or column to a report?
![Samuel Mueller](https://us.v-cdn.net/6031209/uploads/userpics/B9G8B70WXQWC/nKTI46EH9WQOM.jpg)
Is it possible to use bridge to add source sheets to a report?
Also, it is possible to add columns to reports with bridge?
Best Answer
-
Hi @Samuel Mueller ,
It looks like we can use the Get Report in the Smartsheet module to pull the scope (sheets that feed the report) of the report, but when it comes to adding another sheet to the scope, it looks like you can try using the "Array management-add object to array" utility to add another sheet to it. Here's the Smartsheet API information about reports.
I'm not sure about the add columns to reports though. It looks like the columns in reports have "virtualids" that are representations of the actual column id from the various source sheets. I'd recommend submitting a support ticket to see if that team can help answer this!
Answers
-
Hi @Samuel Mueller ,
It looks like we can use the Get Report in the Smartsheet module to pull the scope (sheets that feed the report) of the report, but when it comes to adding another sheet to the scope, it looks like you can try using the "Array management-add object to array" utility to add another sheet to it. Here's the Smartsheet API information about reports.
I'm not sure about the add columns to reports though. It looks like the columns in reports have "virtualids" that are representations of the actual column id from the various source sheets. I'd recommend submitting a support ticket to see if that team can help answer this!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives