Formulas and Functions

5, \"Green\", IF([Operations Metric]1, \"Yellow\")))","categoryID":322,"dateInserted":"2020-09-02T20:08:19+00:00","dateUpdated":null,"dateLastComment":"2020-09-03T12:25:07+00:00","insertUserID":125719,"insertUser":{"userID":125719,"name":"John Littler","url":"https:\/\/community.smartsheet.com\/profile\/John%20Littler","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wpNNPwQhvfo!uidap8QQmDo!EZ4Jh41s4vN","dateLastActive":"2023-08-21T20:47:26+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":3,"countViews":102,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71038\/ryg-balls-on-simple-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71038\/ryg-balls-on-simple-formula","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-02T20:43:10+00:00","dateAnswered":"2020-09-02T20:21:49+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":70787,"type":"question","name":"Sum(Children())","excerpt":"Another basic question - I have a column that uses the value in the 'Remaining Effort' to calculate the status of that task. At the Parent Level I am using Sum(Children()) to sum the Remaining Effort for the Child tasks. This works fine as long as there is a value in this field - if the Task has not started and 'Remaining…","categoryID":322,"dateInserted":"2020-08-21T19:00:40+00:00","dateUpdated":null,"dateLastComment":"2020-09-03T11:55:16+00:00","insertUserID":124656,"insertUser":{"userID":124656,"name":"Nigel Michell","url":"https:\/\/community.smartsheet.com\/profile\/Nigel%20Michell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-24T19:00:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":124656,"lastUser":{"userID":124656,"name":"Nigel Michell","url":"https:\/\/community.smartsheet.com\/profile\/Nigel%20Michell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-24T19:00:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":22,"countViews":765,"score":null,"hot":22,"url":"https:\/\/community.smartsheet.com\/discussion\/70787\/sum-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70787\/sum-children","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-02T20:18:34+00:00","dateAnswered":"2020-09-02T19:55:22+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":71027,"type":"question","name":"Specific Document Pages","excerpt":"Hi everyone, I've created a tracking sheet for multiple directives. We have a document that is produced every fiscal year to publish these directives. In one column we've listed the page number of the document that represents the directive. Is there a way to link the cell to a specific page within a document? I understand…","categoryID":322,"dateInserted":"2020-09-02T16:27:58+00:00","dateUpdated":null,"dateLastComment":"2020-09-03T09:22:08+00:00","insertUserID":125387,"insertUser":{"userID":125387,"name":"Lila De Vera","url":"https:\/\/community.smartsheet.com\/profile\/Lila%20De%20Vera","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BqDeQW6uPGY!wx9f_6KbvvQ!zYdjWnf2PiH","dateLastActive":"2021-10-29T17:42:05+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":1,"countViews":52,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71027\/specific-document-pages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71027\/specific-document-pages","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":71012,"type":"question","name":"Pulling the last 50 results from long database?","excerpt":"I've got pages of test results (numerical values) that go back years that need displaying on a graph. New results get recorded every week. I'm after a way of making a chart that automatically updates to the latest x number of results (A year of results probably). The way the graphs work, they look at a fix range of cells…","categoryID":322,"dateInserted":"2020-09-02T12:39:43+00:00","dateUpdated":null,"dateLastComment":"2020-09-03T07:12:48+00:00","insertUserID":113251,"insertUser":{"userID":113251,"name":"Graham Rimell","url":"https:\/\/community.smartsheet.com\/profile\/Graham%20Rimell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!phHXaR85t_4!pQNXKZdkrro!I0_JXjc_J5c","dateLastActive":"2022-03-16T07:34:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":113251,"lastUser":{"userID":113251,"name":"Graham Rimell","url":"https:\/\/community.smartsheet.com\/profile\/Graham%20Rimell","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!phHXaR85t_4!pQNXKZdkrro!I0_JXjc_J5c","dateLastActive":"2022-03-16T07:34:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":72,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71012\/pulling-the-last-50-results-from-long-database","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71012\/pulling-the-last-50-results-from-long-database","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":71034,"type":"question","name":"RYG formula for indicating expense vs. budget","excerpt":"Hi, I am trying to use RYG balls to indicate how much remains in a budget (red indicates 90% spent, Yellow indicates 75% spent) Using this formula, I get green and yellow, but I can't seem to get red, even though there are expense\/budget over 90% =IF(Charged14 \/ [Budget Allocated]14 > 0.75, \"Yellow\", IF(Charged14 \/ [Budget…","categoryID":322,"dateInserted":"2020-09-02T18:15:39+00:00","dateUpdated":null,"dateLastComment":"2020-09-02T20:01:13+00:00","insertUserID":123999,"insertUser":{"userID":123999,"name":"Amy Martin","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Martin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5rnVuZsDfLw!GeFWHnMXrnw!XYDy0ED2Ioa","dateLastActive":"2022-04-27T14:19:37+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":3,"countViews":115,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/71034\/ryg-formula-for-indicating-expense-vs-budget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71034\/ryg-formula-for-indicating-expense-vs-budget","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-02T19:51:03+00:00","dateAnswered":"2020-09-02T19:42:20+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":71033,"type":"question","name":"If with multiple criteria along with VLookup","excerpt":"I am looking to use an \"If\" statement with multiple criteria combined with a VLookup. Within the formula below, I want the result to be blank if the Vlookup result is any of the terms I have specified, if it does not match, I want the Vlookup result to stand. =IF(OR(VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false) =…","categoryID":322,"dateInserted":"2020-09-02T17:57:14+00:00","dateUpdated":null,"dateLastComment":"2020-09-02T20:00:29+00:00","insertUserID":121641,"insertUser":{"userID":121641,"name":"Ross Novotny","url":"https:\/\/community.smartsheet.com\/profile\/Ross%20Novotny","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nzjV_y9PACY!!F2G1tCE_o9C","dateLastActive":"2023-08-24T16:44:14+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":74,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/71033\/if-with-multiple-criteria-along-with-vlookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71033\/if-with-multiple-criteria-along-with-vlookup","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-02T19:56:54+00:00","dateAnswered":"2020-09-02T19:49:50+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":71002,"type":"question","name":"Determining Exact Match for Multiple Criteria in a Multiple Selection Dropdown","excerpt":"I am trying to grade a quiz where the answers were submitted via a smartsheet form. I am having trouble figuring out how to confirm that there is an exact match on questions that had multiple answers needing to be selected to be considered correct. On questions that only use one answer, this is the formula I use:…","categoryID":322,"dateInserted":"2020-09-01T20:22:17+00:00","dateUpdated":"2020-09-01T20:22:35+00:00","dateLastComment":"2020-09-02T19:40:51+00:00","insertUserID":125686,"insertUser":{"userID":125686,"name":"Thomas Conaboy","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Conaboy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T17:27:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":125686,"lastUserID":125686,"lastUser":{"userID":125686,"name":"Thomas Conaboy","url":"https:\/\/community.smartsheet.com\/profile\/Thomas%20Conaboy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-23T17:27:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":164,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71002\/determining-exact-match-for-multiple-criteria-in-a-multiple-selection-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71002\/determining-exact-match-for-multiple-criteria-in-a-multiple-selection-dropdown","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-09-02T19:36:06+00:00","dateAnswered":"2020-09-01T21:57:18+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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources