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

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Keith Wood

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

Genevieve P.

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

Keith Wood

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å

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.