creating a pie chart of yes/no responses
Hi there,
I have a smartsheet where 1 column is a yes/no column. I am trying to create a Dashboard with a pie chart that breaks down the percentage of yes responses and the percentage of no responses. I need some serious help, as I am getting a lot of error messages and cannot figure out where to even start.
Answers
-
Anson Cheung ✭✭✭✭Hi Jordan, You need to create the metrics by counting the Yes/No column first and then create a pie chart sourced from the metrics. e.g.
--Anson
Help Article Resources
Categories
You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.<\/p>
<\/p>
If you are ok with the link being in another column, you can use this formula:<\/p>
=\"www.acmetickets.com\/ticket\/\" + [Ticket Number Column Name]@row <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":331,"urlcode":"hyperlink","name":"hyperlink"}]},{"discussionID":106493,"type":"question","name":"Need a formula to take a filename and alter the text","excerpt":"I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores. Filename example: JK_T1_L1_NewFile The filename always follows this rules - 2 letters_2 letters__2 letters _filename I…","categoryID":322,"dateInserted":"2023-06-15T14:06:14+00:00","dateUpdated":"2023-06-15T14:15:38+00:00","dateLastComment":"2023-06-15T15:31:51+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T14:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162413,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T15:37:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3373682885,"url":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","format":"Rich","lastPost":{"discussionID":106493,"commentID":380824,"name":"Re: Need a formula to take a filename and alter the text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380824#Comment_380824","dateInserted":"2023-06-15T15:31:51+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T15:37:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T15:34:11+00:00","dateAnswered":"2023-06-15T14:16:00+00:00","acceptedAnswers":[{"commentID":380785,"body":"
Try this:<\/p>
=LOWER(SUBSTITUTE([Column Name]@row, \"_\", \"\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
