Data Bars (%Progress) in Cells
In MS Excel, you can use the Data Bars feature under the Conditional Formatting menu to create data bars within the cells. These can represent % Progress (see attached example). Is there a feature in Smartsheet that allows this?
The Progress Bar under the Visual symbols is in 25% increments depending on selection of "quarter, half........". Can this show the actual numerical values and represented by the filling of the bar?
Comments
-
Hello,
As you mentioned, the progress bar (under the Symbols column) is incremented by 25%. There currently isn't a way to change this so that the actual percentage is displayed, but this would be a great opportunity to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
Another way to visually display the % Complete, is by switching the sheet to Gantt View —a progress bar will appear within the task bar (if the % Complete column has been assigned and contains values). You could also change the display label to the % Complete column.
To change the display label you'll want to edit the Project Settings, select Timeline Display, and select the % Complete column under "Display label for". If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives