Creating a chart
I want to create a chart using 2 columns. The first column is task area, the second column is status. I want the bar graph to illustrate the status of each task area so I can add it to my dashboard.
Answers
-
Smartsheet Charts require numerical data in order to map it to a graph (see: Compare Data with a Chart). This means that if your status is set in text then the chart won't be able to identify what that text means in terms of how high a bar should be displayed.
What I would do is set up a third column that puts a numerical value associated with each status, for example:
0 = Not Started
1 = First Stage
2 = Second Stage... etc
You can have this helper column auto-populate with the correct number by using a Change Cell workflow to update the cell when a new status is input.
Then in your Dashboard, have a legend on the side which explains what each of the numbers represents, like so:
If I've misunderstood and you're looking to see a count of how many different tasks are in each respective status, then in this case you could create a Report and using the Grouping and Summary feature to automatically created these calculations. Then you can use the Summary rows from this Report as the source for your Chart.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives