Formulas and Functions

TODAY()), \"Mild\",IF(And([Client]1= \"Not…","categoryID":322,"dateInserted":"2019-07-09T13:41:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T15:56:27+00:00","insertUserID":11311,"insertUser":{"userID":11311,"name":"Michelle Phillips","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20Phillips","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WpPMHzkqXfw!XFFPn3CaCfw!UeQ6wlOEHYx","dateLastActive":"2023-03-01T15:25:10+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":154,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/52481\/unparseable-error-being-returned","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52481\/unparseable-error-being-returned","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":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":52526,"type":"discussion","name":"Sumif or ifs...","excerpt":"Hi, I want to sum a column based on multiple criteria from one column. I have accomplished this in the following way: =SUMIF({Stage}, \"Proposed\", {Volume}) + SUMIF({Stage}, \"Sold\", {Volume}) Is this the best way to do this or is there a cleaner way to accomplish the same thing. Thanks!","categoryID":322,"dateInserted":"2019-07-09T17:01:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T12:33:44+00:00","insertUserID":95456,"insertUser":{"userID":95456,"name":"PattiWatson","url":"https:\/\/community.smartsheet.com\/profile\/PattiWatson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T15:41:23+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":3,"countViews":114,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/52526\/sumif-or-ifs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52526\/sumif-or-ifs","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":52521,"type":"discussion","name":"Graphing Sumif Data for Date Specific Criteria","excerpt":"Hi Newbie here... My first attempt at creating a graphical \/ chronological representation of Date specific ALLOCATION subtotals has resulted in an #invalidoperation message. Goal is to show Users combined ALLOCATION on the Y-axis over time increments (wks, mo, etc.) I'm sure you guys have already done this one so any help…","categoryID":322,"dateInserted":"2019-07-09T16:55:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T07:52:06+00:00","insertUserID":95451,"insertUser":{"userID":95451,"name":"AMOSELEY95451","url":"https:\/\/community.smartsheet.com\/profile\/AMOSELEY95451","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-09T16:49:17+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":63,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/52521\/graphing-sumif-data-for-date-specific-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52521\/graphing-sumif-data-for-date-specific-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"}],"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":52001,"type":"discussion","name":"nested ifs with greater than less than- #unparseable","excerpt":"Wrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), \"Red\", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), \"Yellow\", IF(AND([Last review date]1 < 275, [Last review date]1 > 0), \"Green\", \"//www.santa-greenland.com/community/categories/formulas-and-functions/\")))","categoryID":322,"dateInserted":"2019-07-01T15:38:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T07:37:08+00:00","insertUserID":91326,"insertUser":{"userID":91326,"name":"AndyGfmr","url":"https:\/\/community.smartsheet.com\/profile\/AndyGfmr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-08T09:29:40+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":165,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/52001\/nested-ifs-with-greater-than-less-than-unparseable","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52001\/nested-ifs-with-greater-than-less-than-unparseable","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":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":52471,"type":"discussion","name":"Can I Auto Assign Tasks to Myself?","excerpt":"When creating a new task can I have it automatically assign it to myself?","categoryID":322,"dateInserted":"2019-07-09T12:36:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-09T15:17:31+00:00","insertUserID":51536,"insertUser":{"userID":51536,"name":"Les","url":"https:\/\/community.smartsheet.com\/profile\/Les","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-09T14:39:54+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":3,"countViews":294,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/52471\/can-i-auto-assign-tasks-to-myself","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52471\/can-i-auto-assign-tasks-to-myself","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":215,"urlcode":"templates","name":"Templates"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":52276,"type":"discussion","name":"do not run formula if cell is blank","excerpt":" Hello, I am a new Smartsheet user. I have search some previous inquiries on this topic and tried the suggestions but I cannot seem to get it right. What do I need to add so the formula will not run if the check-in and check-out dates are blank? =NETDAYS([Check-In]1, [Check-Out]1 - 1) Thank you so much for your help. ","categoryID":322,"dateInserted":"2019-07-04T18:52:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-09T13:32:33+00:00","insertUserID":91111,"insertUser":{"userID":91111,"name":"Nancy Skoulphong","url":"https:\/\/community.smartsheet.com\/profile\/Nancy%20Skoulphong","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpjCvyknuyY!hZtAoeVY9DQ!wmyxB_J_mhK","dateLastActive":"2023-07-14T03:14:51+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":104,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/52276\/do-not-run-formula-if-cell-is-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52276\/do-not-run-formula-if-cell-is-blank","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-07\/5e\/4d\/5e4da0635aa9af9c14db74aacbd094b0.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.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":249,"urlcode":"education","name":"Education"},{"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":52456,"type":"question","name":"Combining \"IF\" formulas with \"IFERROR\" formulas","excerpt":"I am attempting to return a simple YES or NO if a company I have is in another sheet. I created a match formula in one column and in the adjacent column, I was hoping to do a simple IF statement to return the appropriate results. Due to the companies which did not return a match being populated with a #NO MATCH error, I am…","categoryID":322,"dateInserted":"2019-07-09T10:30:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-09T12:45:05+00:00","insertUserID":95371,"insertUser":{"userID":95371,"name":"Doublej3333","url":"https:\/\/community.smartsheet.com\/profile\/Doublej3333","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/71\/c6\/n71c626657ddbadb1f1da4d6d57a075bc.jpg","dateLastActive":"2019-07-09T10:23:32+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":33767,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/52456\/combining-if-formulas-with-iferror-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/52456\/combining-if-formulas-with-iferror-formulas","format":"Html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-19T12:33:53+00:00","dateAnswered":"2019-07-09T10:39:17+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources