How to Create a Chart without Numeric Value

rgallego18 · 01/20/19

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

Mike Wilday · 01/21/19

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 · 01/27/19

Hi Mike, Really the appreciate the help! Thank you

Mike Wilday · 01/28/19

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

rgallego18 · 01/30/19

I did Thanks again!!!

Mike Wilday · 01/30/19

You're welcome!

How to Create a Chart without Numeric Value

Comments

Categories