add a source sheet or column to a report?
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
- 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