nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Sign in to vote on this idea

Add a widget to add requests to dashboard

BrannonChurch

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

Find more posts tagged with

Idea Submitted

Comments

Genevieve P.

Hi @BrannonChurch

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

BrannonChurch

Thank you Genevieve!

Will this solution work for pulling requests from multiple sheets?

Genevieve P.

Hi @BrannonChurch

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.