how to build an interactive dashboard

If I have a dataset looks like below:

Project_ID Approval_Status

P1 Approved

P2 Declined

P3 In approving

P4 Approved

is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in the frame and view the approval status on the right in a text box.

Find more posts tagged with

Integrations

Project Management

Comments

sean59916

Not elegantly, no.

I have created something similar for a client with an intermediate step where the users selects the project ID on a sheet and then clicking on a url in that sheet to show the results for the selected project on a dashboard.

Sean

Andrée Starå

Hi,

Yes, there are a few different ways to do it. Here's one.

A sheet as a web content widget that is set up to with a drop-down with the projects and then that would show the approval status in the next column.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I second Andree's suggestion. And to keep the dashboard looking a little cleaner, the URL Widget can be resized so that you can only see those two particular cells.

Sign in to join the conversation!

Quick Links

Trending discussions

Onedrive & DocuSign Integration Capabilities
I am in the process of designing our Smartsheets workflow and am trying to better understand the capabilities / limitations of these integrations. Current Process: 1) We receive a PDF (say an invoice). 2)Manually save the file in Onedrive updating the file name. 3) Manually enter the data from the PDF into a SS Form and…
Dynamic View - Loading Issues
Is anyone experiencing issues with Dynamic View showing a bunch of blank flashing rows when loading instead of the normal revolving circle that says loading? As a result, it shows the flashing rows for a bit and then nothing to display despite the fact it should be displaying certain data for users. We have shared groups…
DocuSign Status Column Not Updating Consistently (Non-Mapping Issue)
Hi Smartsheet Community, We’re hoping to tap into the collective expertise here about a DocuSign integration issue. Here’s our setup: •All information is collected via a Smartsheet form. •Based on certain cell values, one of several DocuSign integrations is triggered. •Documents are generated and routed correctly in…