Discussions
=9\") Detractors: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How…","categoryID":322,"dateInserted":"2023-06-15T12:23:10+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T12:45:19+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156658,"lastUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":54,"score":null,"hot":3373666109,"url":"https:\/\/community.smartsheet.com\/discussion\/106486\/net-promoter-score-calculation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106486\/net-promoter-score-calculation","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T12:45:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":105335,"type":"question","name":"Total from Dropdown column with multiple values","excerpt":"Hello all. I have a sheet with columns with multiple (20+) dropdown options. A cell can contain more than one dropdown item I want to create a report to go up to a dashboard that shows the count of each time a dropdown is used regardless of whether it's on its own in a cell or with other items. e.g. over 10 rows from 1…","categoryID":321,"dateInserted":"2023-05-17T13:36:57+00:00","dateUpdated":"2023-06-12T15:20:41+00:00","dateLastComment":"2023-06-12T15:17:56+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-10-27T18:29:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":189,"score":null,"hot":3370917893,"url":"https:\/\/community.smartsheet.com\/discussion\/105335\/total-from-dropdown-column-with-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105335\/total-from-dropdown-column-with-multiple-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-12T13:38:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":105224,"type":"question","name":"Intelligent Reporting","excerpt":"Hello. We have a portfolio of projects, each with their own risk register. Is it possible that when a risk is added\/updated with a certain score, e.g.15 and above, that the line can automatically be added to a different sheet, i.e. the programme risk register. I don't want multiple entries for the same risk on different…","categoryID":321,"dateInserted":"2023-05-15T14:34:08+00:00","dateUpdated":null,"dateLastComment":"2023-05-17T13:32:50+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156658,"lastUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":46,"score":null,"hot":3368492818,"url":"https:\/\/community.smartsheet.com\/discussion\/105224\/intelligent-reporting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105224\/intelligent-reporting","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-16T11:41:46+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"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}]},{"discussionID":105173,"type":"question","name":"Remove File from Shortcut Widget","excerpt":"Hello I have the shortcut widget with a number of files linked. One is no longer relevant so I want to remove it, but I can't seem to. There is only the 'Add Shortcut' option. I can click it but that only gives me the option to edit the text but even if I remove the text, the icon is still there and the icon can be…","categoryID":321,"dateInserted":"2023-05-12T13:31:25+00:00","dateUpdated":null,"dateLastComment":"2023-05-15T14:28:26+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156658,"lastUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":96,"score":null,"hot":3368060391,"url":"https:\/\/community.smartsheet.com\/discussion\/105173\/remove-file-from-shortcut-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105173\/remove-file-from-shortcut-widget","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-12T14:14:17+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":531,"urlcode":"links","name":"Links"},{"tagID":533,"urlcode":"web-content-widget","name":"web content widget"}],"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}]},{"discussionID":101187,"type":"question","name":"Sumif","excerpt":"Hello I'm rubbish with formulas! I know what I want to achieve, but even reading explanations confuses me! I have a column which has a load of numbers against each row, e.g. 3,345, 8,451 etc and I have a column of 'feeds enabled' with yes no responses. Therefore in my summary I want a total count which is for all the rows…","categoryID":322,"dateInserted":"2023-02-15T17:20:37+00:00","dateUpdated":null,"dateLastComment":"2023-02-16T10:23:26+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-10-28T13:20:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":66,"score":null,"hot":3353027043,"url":"https:\/\/community.smartsheet.com\/discussion\/101187\/sumif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101187\/sumif","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-16T11:53:39+00:00","dateAnswered":"2023-02-15T18:39:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]},{"discussionID":100850,"type":"question","name":"Using COUNTIF in Summary","excerpt":"Hello I'm looking to create a dashboard. I've got a column in a sheet that has 'Not Started', 'In Progress', 'Complete' as options. I could do with a report that shows 'Not Started' = x and 'In Progress' = y etc. How do I go about this? Ideally I'd like to put Countif into the Summary rather than update it manually as the…","categoryID":322,"dateInserted":"2023-02-08T14:59:05+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T16:11:53+00:00","insertUserID":156658,"insertUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":156658,"lastUser":{"userID":156658,"name":"KatieDi","url":"https:\/\/community.smartsheet.com\/profile\/KatieDi","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!D0noA49SwTI!hyEl4Rv84Go!g2BoZaeElA6","dateLastActive":"2023-09-18T14:05:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":66,"score":null,"hot":3351742258,"url":"https:\/\/community.smartsheet.com\/discussion\/100850\/using-countif-in-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100850\/using-countif-in-summary","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-08T15:12:12+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">