Is there a way to use a Report's "Summary/Summarized" value on Dashboard or Sheet?

Ami Veltrie ✭✭✭✭✭✭

05/07/21 in Formulas and Functions

Now that Reports summarize data (ie count), how can I use that value/result in a dashboard or metric sheet (via cell link)? Neither dashboards or cell links allow me to use 'reports' as the source data.

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Mark Cronk ✭✭✭✭✭✭

  05/08/21 Answer ✓

  Hi Ami,

  You can't use the report summaries as dashboard widgets. That would be a useful feature though. You could submit it as an enhancement, link below.

  Mark

  https://app.smartsheet.com/b/m?lgt=wf&lrt=s&ss_v=114.0.2&EQBCT=739aa75f30ca43a8a22eb53e4da7d409

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  2 · Share on FacebookShare on Twitter

Answers

• 

  Mark Cronk ✭✭✭✭✭✭

  05/08/21 Answer ✓

  Hi Ami,

  You can't use the report summaries as dashboard widgets. That would be a useful feature though. You could submit it as an enhancement, link below.

  Mark

  https://app.smartsheet.com/b/m?lgt=wf&lrt=s&ss_v=114.0.2&EQBCT=739aa75f30ca43a8a22eb53e4da7d409

  
  

  I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  2 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list