add a source sheet or column to a report?

Samuel Mueller

Is it possible to use bridge to add source sheets to a report?

Also, it is possible to add columns to reports with bridge?

Diana Yeh

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!

Diana Yeh

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!