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, pleaseVisit the Current Forums.
I know Labs isnt officially supported, but I thought someone on here might know what I'm doing wrong.
I have a very basic data set I am trying to graph using Charts.
basiclly a date and a volume delivered:
Eg: 13/01/2017 525
14/01/2017 612
15/01/2017 599
Etc.
However, when ever I choose a graph option, i get this error message, and I have no idea what it actually means or how to fix it. Any help is appreciated! Thanks guys
All series on a given axis must be of the same data type
What they mean (I believe) is "don't count on this being available always, its beta!")
That said, you did not post what your error message is, but I can guess.
I don't think the Charts supports dates or text as values. I can't remember if I got that to work or found a different way to do things. Are you getting a message about a "data type"? That's probably why then.
Craig is right Kylie and I would add, that we have recommending Graphs to our clients and been using the Graphs in Smartsheet labs for years now and never had a reliability issue so far. Real time Graphs are an excellent way to see your KPI data.
Setting this up for the first time could be slightly more intuitive, so if you dont get the exact help you need from smartsheet support i'm happy for one of my team (Craig if he's free) to help you set this up as part of our free initial consultancy offer.
Email[email protected]and provide the steps you were taking that lead up to the error, and a screenshot of the error.
Since Labs apps are experimental, the team might log this as a bug (meaning they can't provide you with an immediate fix) if they don't have a workaround.
Although it's not officially supported, our Labs team values feedback and would love to know more about the error that is occurring.
Ok, how about using a helper column with a 0 or 1 being input by your automation, and then use this as the trigger. So set the default on the column to 0, and if an attachment is there, leave it at 0. Then if an attachment is not there workflow will set it to 1, and that would trigger the automated workflow to run.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":108318,"type":"question","name":"Count to show the High Priority Items","excerpt":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","snippet":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","categoryID":322,"dateInserted":"2023-07-31T18:51:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":121230,"lastUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":null,"hot":3381664822,"url":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","format":"Rich","lastPost":{"discussionID":108318,"commentID":388103,"name":"Re: Count to show the High Priority Items","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388103#Comment_388103","dateInserted":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/382QSC10NTUW\/count-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"count.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T19:48:14+00:00","dateAnswered":"2023-07-31T19:18:51+00:00","acceptedAnswers":[{"commentID":388092,"body":"