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
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives