Formulas and Functions

\"Approved\", @cell <> \"Rejected\", @cell <> \"Withdrawn\")) However everything…","categoryID":322,"dateInserted":"2019-03-15T11:52:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T14:32:06+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-07-05T23:33:32+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"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-07-07T16:20:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":93,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-criteria","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":274,"urlcode":"Legal","name":"Legal"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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":43736,"type":"discussion","name":"Changing cell to \"0\" if checkbox is checked","excerpt":"Wondering if it is possible to change a cell to \"0\" if the checkbox is checked. I'm assuming a formula will need to be used since I was unable to find it in the conditional formatting. Thank you for your help in advance. ","categoryID":322,"dateInserted":"2019-03-15T13:24:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T13:37:19+00:00","insertUserID":82041,"insertUser":{"userID":82041,"name":"Sarah.Humpal82041","url":"https:\/\/community.smartsheet.com\/profile\/Sarah.Humpal82041","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-15T13:20:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-07T14:38:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":329,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/43736\/changing-cell-to-0-if-checkbox-is-checked","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43736\/changing-cell-to-0-if-checkbox-is-checked","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":281,"urlcode":"Support","name":"Support"},{"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":43646,"type":"discussion","name":"Formula Count Help","excerpt":"May I please get assistance with a formula? I am trying to do a formula that references another sheet (Loaner Sign Out Sheet), which calculates a total from that onto my Request Metrics sheet. Please see attached. I would like a total count for Request Type \"HDMI\" only if the Status states \"In Progress.\" If it's not in…","categoryID":322,"dateInserted":"2019-03-14T18:00:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T09:43:01+00:00","insertUserID":81926,"insertUser":{"userID":81926,"name":"Tori Peregoy","url":"https:\/\/community.smartsheet.com\/profile\/Tori%20Peregoy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/20\/6d\/n206d2edc6cfadf37620be540eb41c2fc.jpg","dateLastActive":"2019-07-29T15:58:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-07-07T16:20:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":52,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/43646\/formula-count-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43646\/formula-count-help","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-03\/cc\/85\/cc85804763aeaeb58056cebb5dc44511.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula Help Example.jpg"},"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":43606,"type":"discussion","name":"Is there a way to use SumIF to add values in a column that match a specific text string in adjacent","excerpt":"We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent \/ children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…","categoryID":322,"dateInserted":"2019-03-14T13:30:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T08:52:49+00:00","insertUserID":81876,"insertUser":{"userID":81876,"name":"Burt L","url":"https:\/\/community.smartsheet.com\/profile\/Burt%20L","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-23T16:17:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-07-07T16:20:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":633,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/43606\/is-there-a-way-to-use-sumif-to-add-values-in-a-column-that-match-a-specific-text-string-in-adjacent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43606\/is-there-a-way-to-use-sumif-to-add-values-in-a-column-that-match-a-specific-text-string-in-adjacent","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}">

Help Article Resources