Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Assigned To/ Status chart

Liam Simpson
edited 12/09/19 in Archived 2015 Posts

Hi Everyone,


I am trying to create a chart using the app in Smartsheet labs which displays the number of projects per handler and split into the status. I can create a Bar Chart showing the count of projects per handler but when I try and make a similar chart which splits the count by status it says that I can't.


The issue is that in order to make the handler count chart I have to select 'Calculate my data before charting'  which only allows me to select one 'Group By' catagory. When I try to use the 'Chart my data' option it says 'Data column(s) for axis #0 cannot be type of string'.


What should I do to reslove this?


Thanks in advance





  • Hi Liam,


    That error is caused when some of the data being imported is non numeric data, or a "string" rather than a "number". 


    There are certain graphs that cannot create a graph out of non-numeric characters and will throw out this error. I've found this more common when you have multiple text columns selected. If you deselect the text columns when importing the data you should not see this error. 


    If you still have issues, shoot an email to [email protected] and we'll continue troubleshooting.

  • Hi Josef,


    Thanks so much for your reply.


    The issue is that it is the 'count' of non-numeric text which I need to chart, status and handler. If I just want to chart one of these then I can use the count function when creating a chart but when both are selected I cannot. Does this mean that I will need to count them manually (or using a formula) on a seperate sheet and make the graph from that?


    Many Thanks,


  • Hi Liam,


    I got your email to [email protected] and I'll respond to your question via that channel.




  • As of right now tallying off of multiple columns is not currently available.


    The work around would be to add up the columns manually or use a formula to count the columns, then use a single column as your data point.



This discussion has been closed.