Any Potential for Linking Reports to Sheets?

Allison_S

Hello, 

I wish there was a way to link a report to a sheet - does anyone know how to do this, or is it possible? I am hitting my link capacities for our production reporting, but what I really wish I could do is to sum a qty in a report and then graph it on a dashboard. 

Is there anything in the works at Smartsheets Headquarters for this? 

Any suggestions would be greatly appreciated. Thank you.

Alejandra

Hi Allison,

It’s currently not possible to build formulas in a report, but please feel free to submit a Product Enhancement Request (you’ll find a link to this here in Community under Quick links on the right).

In the meantime, if you want to sum a series of numbers from multiple sheets, you could do so using cross sheet references. If needed, more information on this can be found here: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

Allison_S

Hi Alejandra, 

Thank you for your suggestion. I already have cross-reference sheets set up and functioning, but I am hitting my capacities within the max cell links before the end of the year wrapped up. 

Thanks again,

Allison