Add a widget to add requests to dashboard

I need an option to add a simple widget that shows a list of active requests.

Sign in to vote!

There are a few ways to do this:

Create a Report from your sheet with a filter to only show active requests, then use the Report Widget
OR - use a Report with Grouping and Summary to generate numbers, then display this in a Chart Widget or a Report Widget
Use a formula, such as COUNTIF, to generate a number in either a Sheet Summary field or another sheet, then use the Metric Widget to display that number (or Chart if you have multiple numbers)

Cheers,

Genevieve

Thank you Genevieve!

Will this solution work for pulling requests from multiple sheets?

If you're on a Business or Enterprise plan, you can use a Row Report with multiple sheets as the source for the Report, yes! 🙂

You can also add multiple COUNTIF statements together (each looking at a different sheet) if you want a numerical summary.

Make dashboard widgets interactive and drillable (click into segments like Tableau)
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
Fix API documentation for "Alternate Email addresses" and improve Bad Error Messages
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…
Administrator Control on License Banner
Dear Smartsheet, You really need to add an administrator-controlled option to manage the license banner display for free users. The banner not being able to be removed by the administrators presupposes that the administrator wants the free users to have licenses. One of the main reasons we love Smartsheet is the ability to…