Formulas

=07\/01\/2017\",{Completed…","categoryID":322,"dateInserted":"2018-07-09T08:58:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-12T11:47:13+00:00","insertUserID":50196,"insertUser":{"userID":50196,"name":"Margaret Griffin","url":"https:\/\/community.smartsheet.com\/profile\/Margaret%20Griffin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/15\/5a\/n155a75066e9cc022fd49bc59a0f1121d.JPG","dateLastActive":"2023-08-24T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":50196,"lastUser":{"userID":50196,"name":"Margaret Griffin","url":"https:\/\/community.smartsheet.com\/profile\/Margaret%20Griffin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/15\/5a\/n155a75066e9cc022fd49bc59a0f1121d.JPG","dateLastActive":"2023-08-24T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":214,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/28156\/using-a-countifs-formula-to-calculate-of-rows-in-a-set-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28156\/using-a-countifs-formula-to-calculate-of-rows-in-a-set-date-range","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":28376,"type":"discussion","name":"Tips for Showing Count of Answers Completed on a Smartsheet?","excerpt":"If I have a section with three rows underneath my heading, I'm able to easily use a formula to show the count of tasks completed\/responded to out of my total number: =\"Introduction: \" + COUNT(Response4:Response6) + \" of \" + COUNT(CHILDREN()) However, if I have a section with multiple sub-sections, I'm struggling to use a…","categoryID":322,"dateInserted":"2018-07-11T14:41:22+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-12T07:28:03+00:00","insertUserID":54091,"insertUser":{"userID":54091,"name":"Steven Nolan","url":"https:\/\/community.smartsheet.com\/profile\/Steven%20Nolan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-11T14:38:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":34096,"lastUser":{"userID":34096,"name":"Luke X","url":"https:\/\/community.smartsheet.com\/profile\/Luke%20X","photoUrl":"https:\/\/lh5.googleusercontent.com\/-2wo5MDm5Ux4\/AAAAAAAAAAI\/AAAAAAAAACs\/MfrgdtKrHPM\/photo.jpg","dateLastActive":"2020-03-03T20:32:21+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":143,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/28376\/tips-for-showing-count-of-answers-completed-on-a-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28376\/tips-for-showing-count-of-answers-completed-on-a-smartsheet","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-07\/2e\/9c\/2e9cda507df9c9e756f265ff9db90172.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2018-07-11 13_40_59-Client Discovery Questionnaire - Smartsheet.com_.png"},"attributes":{},"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"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":28226,"type":"discussion","name":"Display a counter in a bar graph","excerpt":"Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.","categoryID":322,"dateInserted":"2018-07-09T17:23:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-11T13:16:50+00:00","insertUserID":53886,"insertUser":{"userID":53886,"name":"jrf","url":"https:\/\/community.smartsheet.com\/profile\/jrf","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-09T17:17:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":300,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/28226\/display-a-counter-in-a-bar-graph","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28226\/display-a-counter-in-a-bar-graph","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-07\/d3\/06\/d306de7f64d81c026b07059c34768058.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ejemplo grafico.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":249,"urlcode":"education","name":"Education"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":444,"urlcode":"card-view","name":"Card View"}],"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":28311,"type":"discussion","name":"Automatically marking something as complete when requirements are filled","excerpt":"Hello, I was wondering if someone would be able to help me with a problem that I have been struggling with. I would like to make it so that when a checkbox is checked, in another column, called status, that it would switch and say complete. The status column is a Dropbox, containing Completed, In-progress and Not started.…","categoryID":322,"dateInserted":"2018-07-11T05:10:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-11T11:40:56+00:00","insertUserID":53741,"insertUser":{"userID":53741,"name":"sync","url":"https:\/\/community.smartsheet.com\/profile\/sync","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-16T07:36:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":192,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/28311\/automatically-marking-something-as-complete-when-requirements-are-filled","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28311\/automatically-marking-something-as-complete-when-requirements-are-filled","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":28331,"type":"discussion","name":"CountIF incorrect","excerpt":"Im trying to count the number of total number of \"Open\" \"Risks\" in another sheet =COUNTIFS({RAID Log Range 1}, \"Risk\") + (COUNTIFS({RAID Log Range 2}, \"Open\")) I only have 1 open risk but its returning 5. This is because its counting the total number of \"open\" AND \"Risks\" into my count. How do I write the formula to be…","categoryID":322,"dateInserted":"2018-07-11T07:19:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-11T08:25:34+00:00","insertUserID":52911,"insertUser":{"userID":52911,"name":"rlakin52911","url":"https:\/\/community.smartsheet.com\/profile\/rlakin52911","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/5d\/f7\/n5df7bc519e12f1f8a3478f599d4fda94.jpg","dateLastActive":"2023-07-26T17:47:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":40116,"lastUser":{"userID":40116,"name":"p_bureau","url":"https:\/\/community.smartsheet.com\/profile\/p_bureau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-25T02:46:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":64,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/28331\/countif-incorrect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28331\/countif-incorrect","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":28081,"type":"discussion","name":"Card View - Data Entry (Logic & Formulas do not show up)","excerpt":"I went through a lot of trouble to program my Smartsheet with formulas and logic to make sure the data entry was sound. Only to discover that when someone enters data via the card view, things to not do what they do in grid view. I have many columns to populate and the entire point was to make it easy and smart. Does…","categoryID":322,"dateInserted":"2018-07-05T20:52:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-10T08:19:36+00:00","insertUserID":52641,"insertUser":{"userID":52641,"name":"EcoPartnering","url":"https:\/\/community.smartsheet.com\/profile\/EcoPartnering","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-19T00:39:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":52641,"lastUser":{"userID":52641,"name":"EcoPartnering","url":"https:\/\/community.smartsheet.com\/profile\/EcoPartnering","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-11-19T00:39:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":176,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/28081\/card-view-data-entry-logic-formulas-do-not-show-up","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28081\/card-view-data-entry-logic-formulas-do-not-show-up","format":"Html","groupID":null,"statusID":0,"attributes":{},"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"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":444,"urlcode":"card-view","name":"Card View"}],"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":true,"noCheckboxes":false}">