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.
Hi @I have questions
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.
Apologies if this has been previously discussed or in support already. Is there a way to get smartsheet to send an email notification in say 1 month based on the date entered in the cell? i.e. Went to a building site on the below date... smartsheet automatically sends me an email reminder in 1 month from this date to alert…
Hello, I am currently attempting to organize my files in Workspace by creating folders to group them. I am doing this by dragging and dropping sheets from the 'Sheets' folder into my 'Workspace' folder. However, some sheets that I own and created do not appear in the 'Sheets' folder. I even tried editing some details in my…
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.