Charting non-numerical values in a dashboard

Hello,
Forgive me if this is an easy fix, but I'm new to Smartsheet.
I'm trying to chart the status of projects on a dashboard - e.g. 30 in progress, 10 behind schedule, 5 overdue. For metrics, you can simply use a sheet summary and countif and insert the data, but for charts, there's no option to use the sheet summary data.
So I've created a new sheet so that I can use countif to generate the counts. My problem is that my values are returning 0.
The formula I've used is =Countif({Project Status}, "In Progress") which to my lay mind should return the value of 30 where {Project Status} is the name I've used in generating the cross-sheet reference and 30 is the number of projects that have a status of "In Progress".
However, it's returning the value of 0.
I'm obviously doing something very simple wrong but I can't see it.
Any help would be appreciated.
Thanks in Advance!
Keith
Answers
-
Hi @Keith WoodΒ
Hope you are fine, if you share a screenshot ( remove any sensitive date ) i will try to help you
bassam.khalil2009@gmail.com
βοΈ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Keith Wood
Screen captures would help as @Bassam.M Khalil suggested, but from what I can see it may be that your spelling or spacing could be different in your formula. Keep in mind the formula is looking for an exact match, so even one letter out of place will return a 0.
As an alternative, since you already have the data in your Sheet Summary, you could create a Sheet Summary Report out of your Sheet Summary Fields, then use this as the source for your Chart Widget. (See this Help Center article: Sheet Summary Reports).
Let me know if you would like more information on how to do this and I'm happy to provide some screen capture examples!
Cheers,
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
Thanks Bassam and Genevieve. I found a different way around it and it's all good now. I appreciate your assistance though!
Cheers,
Keith
-
Hi @Keith Wood
Excellent!
Glad you got it working!
I hope that helps!
Be safe and have a fantastic weekend!
Best,
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
β Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!