Does smartsheet support the functionality to show progress bars on a Dashboard? If so, how?
I'm looking to create a dashboard to visualize % completion of projects - most of which are multi-stage. To add a cherry on top, some tasks may be completed in different orders, although everything would have to be complete to complete a "stage". If I had to cheaply describe what I'm trying to do, please see image below.
Answers
-
You will need to use an Image widget to get the arrows on there.
For the bottom part, you would use a separate sheet with formulas using cross sheet references to populate the tasks that are in each stage and then use a metrics widget on the dashboard to display them below each arrow.
=JOIN(COLLECT({Task Name}, {Stage}, @cell = "Stage 1"), CHAR(10))
(enable text wrapping)
-
Hmmm maybe I wasn't entirely clear. I'm trying to use the arrows (in this case) as status completion bars. Either filling up as the tasks get complete or change color when complete - whichever seems easier.
-
Hello @ZMinior
I think the closest you can get to this idea is using a bar chart. I've never seen custom shape to use as a progress bar in Smartsheet.
The only thing I can think of is using an external app that can embed code, but the data would have to be sourced from the external app as well.
@Paul Newcome Paul, is there a way to use custom shapes as a progress bar?
-
You can use UNICHAR(11157), make it bold, increase the font size, then use a formula to output a percent complete for the stage, and finally use conditional formatting to change the color of the arrow and have the arrow surfaced on your dashboard using a metrics widget.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives