Any Potential for Linking Reports to Sheets?

Allison_S · 01/03/19

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 · 01/08/19

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 · 01/08/19

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

Any Potential for Linking Reports to Sheets?

Comments

Help Article Resources

Categories