Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
How to Create a Chart without Numeric Value
Hello Everyone,
Certified newbie here. I just need your help on how am I going to create a chart in Smartsheet without a numeric value.
Shared you the screenshot of an example but I covered the sensitive information for security purposes.
I wanted to create a pie graph that displays number of not started projects and completed projects per user.
Thanks in advance.
Comments
-
The only way to chart data is to include numbers so your best bet is to either create a summary section at the top or bottom of your sheet, or use cross-reference formulas to summarize your data in a new sheet. You could use a countifs formula in a new sheet to count the number of not started, and another formuala to count the number of completed.
-
Hi Mike, Really the appreciate the help! Thank you
-
Glad I could be of assistance. Hope you got it all figured out.
-
I did
Thanks again!!! -
You're welcome!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 463 Global Discussions
- 156 Industry Talk
- 509 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
- Hi all, Our org has dozens of workspaces and while we have moved more toward group-based permissions recently, I still have some legacy workspaces that were configured with dozens of individual user a…
- We are looking into transitioning our MS Access Drawing Index into Smartsheet. We need it to have the same filtering and search capabilities if we are to move forward with this transition. In the atta…
