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.

Warnings when approaching functional sheet capacity
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Workflow Automation print in PDF and/or export to Visio
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid
Timeline Widget - Custom Colors
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…