Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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.
Comments
-
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
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
