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":"2021-05-21T19:52:45+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":"2022-11-12T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":79,"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":259,"urlcode":"IT & Operations","name":"IT & Operations"},{"tagID":270,"urlcode":"Technology","name":"Technology"}],"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":"2019-07-09T16:54:44+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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-11-04T20:56:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":79,"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":"2022-11-12T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"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":"2022-11-12T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":107,"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":228,"urlcode":"Project Management","name":"Project Management"},{"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