Charting non-numerical values in a dashboard

Options

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

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Keith Wood 

    Hope you are fine, if you share a screenshot ( remove any sensitive date ) i will try to help you

    PMP Certified

    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"

  • Genevieve P.
    Options

    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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Keith Wood
    Options

    Thanks Bassam and Genevieve. I found a different way around it and it's all good now. I appreciate your assistance though!

    Cheers,

    Keith

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!