How to Create a Chart without Numeric Value

rgallego18

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.

Chart Issue.png

Find more posts tagged with

Comments

Mike Wilday

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.

rgallego18

Hi Mike, Really the appreciate the help! Thank you

Mike Wilday

Glad I could be of assistance. Hope you got it all figured out.

rgallego18

I did Thanks again!!!

Mike Wilday

You're welcome!

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Changing how items are displayed on the calendar
Is there an overall calendar setting whereby I can choose a specific column to display in the calendar view? I have created an additional column that gives the task name (located in a child row) as well as the main task (in it's parent row). I want that to display in the calendar. Overall creating a content calendar and…
True up and the admin center
Hello We converted over in July to the usm. We have alot of discrepancies where people are in usm and not the admin center and vice versa. Is anyone else see the same and feel this is an issue? Also, I would like to brain storm with the group as to how procedurally you will be doing the true up process and terminations as…