Formulas and Functions

\"NYC\", [# People]1:[# People]51) but i want Smartsheet to exclude multiple cities. I've tried a few options but felt…","categoryID":322,"dateInserted":"2020-05-06T20:55:39+00:00","dateUpdated":null,"dateLastComment":"2020-05-07T13:22:29+00:00","insertUserID":121288,"insertUser":{"userID":121288,"name":"Dana Folsom","url":"https:\/\/community.smartsheet.com\/profile\/Dana%20Folsom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/845\/nZ7AFCIJC9NHN.jpg","dateLastActive":"2020-05-20T19:07:13+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-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1894,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68102\/can-i-create-a-sumif-does-not-contain-with-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68102\/can-i-create-a-sumif-does-not-contain-with-multiple-values","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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":68100,"type":"question","name":"Nested If Formula (Multiple Conditions)","excerpt":"Hello, Hoping to get some help for a rather complex nested if formula I'd like to build based on responses to a webform. Below are the conditions. Is this possible to create an if formula around these conditions to result in a a red\/yellow\/green visual symbol? Any help or guidance is much appreciated! Thanks so much!","categoryID":322,"dateInserted":"2020-05-06T20:12:39+00:00","dateUpdated":null,"dateLastComment":"2020-05-07T13:08:07+00:00","insertUserID":121285,"insertUser":{"userID":121285,"name":"Dustin Miller","url":"https:\/\/community.smartsheet.com\/profile\/Dustin%20Miller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-06T21:31:27+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-13T20:48:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":714,"score":1,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68100\/nested-if-formula-multiple-conditions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68100\/nested-if-formula-multiple-conditions","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/625\/8C7EWHD8SPSP.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":68098,"type":"question","name":"Formula that checks if a certain date is in a date range and TRUE\/FALSE VALUES","excerpt":"Hello! I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart. This is the formula page I am using in order to build a gantt chart with a bar chart in a dashboard with month counts and sums. I created this report to show what is needed in the formula. Count: Count…","categoryID":322,"dateInserted":"2020-05-06T19:55:21+00:00","dateUpdated":null,"dateLastComment":"2020-05-07T12:46:04+00:00","insertUserID":121196,"insertUser":{"userID":121196,"name":"Gabriela Colvis","url":"https:\/\/community.smartsheet.com\/profile\/Gabriela%20Colvis","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2tld__RM17o!!VPJ5jj_6h4B","dateLastActive":"2020-05-07T19:46:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":109841,"lastUser":{"userID":109841,"name":"jwilson10533","url":"https:\/\/community.smartsheet.com\/profile\/jwilson10533","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bCHVWx8ISH4!nQjWP2sXDqQ!VzBtgxODPQM","dateLastActive":"2020-12-14T14:40:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":224,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68098\/formula-that-checks-if-a-certain-date-is-in-a-date-range-and-true-false-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68098\/formula-that-checks-if-a-certain-date-is-in-a-date-range-and-true-false-values","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/573\/8MZ7NFRVNCCJ.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":68087,"type":"question","name":"Max(Collect formula","excerpt":"I am trying to put a formula together My result is to identify the most current date based upon each unique Invoice number What am I doing wrong I am getting an incorrect argument Thank you","categoryID":322,"dateInserted":"2020-05-06T15:56:10+00:00","dateUpdated":null,"dateLastComment":"2020-05-07T10:52:56+00:00","insertUserID":17086,"insertUser":{"userID":17086,"name":"Debbie J","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20J","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-05\/9b\/98\/n9b98b9c215278edc2a32641c6a886be0.JPG","dateLastActive":"2023-04-12T16:23:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-14T08:42:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1007,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68087\/max-collect-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68087\/max-collect-formula","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/677\/A3WZSIAUKGRY.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-12T03:59:38+00:00","dateAnswered":"2020-05-07T10:52:56+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":68044,"type":"question","name":"Help with calculating health (R\/Y\/G\/B) based on end date and % complete","excerpt":"Hi, I'm trying to create a formula to auto calculate the health of a task and return the correct R\/Y\/G\/B ball based on the % complete measured against the planned duration and start\/finish dates. I created a couple of helper columns (one calculating 50% & one calculating 75% of the duration as a number) to attempt to get…","categoryID":322,"dateInserted":"2020-05-05T14:21:50+00:00","dateUpdated":"2020-05-05T14:28:49+00:00","dateLastComment":"2020-05-07T09:12:05+00:00","insertUserID":121019,"insertUser":{"userID":121019,"name":"Laurie A","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20A","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-24T22:42:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":121019,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-07-14T08:42:48+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":467,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68044\/help-with-calculating-health-r-y-g-b-based-on-end-date-and-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68044\/help-with-calculating-health-r-y-g-b-based-on-end-date-and-complete","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/119\/G8GWLHUO09VW.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula Help.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-06T18:46:36+00:00","dateAnswered":"2020-05-06T16:09:19+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":68110,"type":"question","name":"Different formula for a cell basing on condition","excerpt":"Hi All, How can i apply different formula basing on cell value? For instance i have a columns Type, Duration, Original If type = \"Sub-Task\" I need formula for Original \"= Duration*1440\" If type = \"Story \" I need formula for Original \"=SUM(CHILDREN())\" i tried IF(Type = \"Sub-Task\" , \"=Duration*1440\", \"=SUM(CHILDREN())\") but…","categoryID":322,"dateInserted":"2020-05-07T06:46:00+00:00","dateUpdated":null,"dateLastComment":"2020-05-07T07:04:47+00:00","insertUserID":121164,"insertUser":{"userID":121164,"name":"Pavel Bogatyrev","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pavel%20Bogatyrev","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-06-27T12:47:47+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-07-14T08:43:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68110\/different-formula-for-a-cell-basing-on-condition","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68110\/different-formula-for-a-cell-basing-on-condition","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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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":68090,"type":"question","name":"Formulas - IF This then do this calculation","excerpt":"Hoping someone can help! I want to do a formula IF Contract ASV is less than 100000, then multiply Contract ASV by .20 and put that amount in the Rev Share 20% of per year ASV in USD field, but IF Contract ASV is greater than 100000, then multiply Contract ASV by .1 and put in the Rev Share 10% of per year ASV in USD…","categoryID":322,"dateInserted":"2020-05-06T17:24:03+00:00","dateUpdated":null,"dateLastComment":"2020-05-06T23:44:51+00:00","insertUserID":121276,"insertUser":{"userID":121276,"name":"Anna W. ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20W.%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-22T12:57:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":121276,"lastUser":{"userID":121276,"name":"Anna W. ","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20W.%20","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-22T12:57:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":72,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/68090\/formulas-if-this-then-do-this-calculation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68090\/formulas-if-this-then-do-this-calculation","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/279\/WZPYX7QWAE5T.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"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":68097,"type":"question","name":"Combine text and sheet cell value in widget chart title","excerpt":"I want my widget chart title to pull in a sheet cell value as part of the title.","categoryID":322,"dateInserted":"2020-05-06T19:55:10+00:00","dateUpdated":null,"dateLastComment":"2020-05-06T20:36:52+00:00","insertUserID":121283,"insertUser":{"userID":121283,"name":"Chandra Merica","url":"https:\/\/community.smartsheet.com\/profile\/Chandra%20Merica","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-05-06T20:44:24+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-07-14T08:43:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":123,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68097\/combine-text-and-sheet-cell-value-in-widget-chart-title","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68097\/combine-text-and-sheet-cell-value-in-widget-chart-title","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-05-06T20:44:35+00:00","dateAnswered":"2020-05-06T20:36:52+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":68099,"type":"question","name":"How to auto-trigger a flag?","excerpt":"I would like to set up a formula that automatically turns the flag icon red when a new risk is identified. What is the formula to automatically turn the flag red when a new risk - any text - is entered under the \"Identified Risk\" column of the same row? I attached a photo to help.","categoryID":322,"dateInserted":"2020-05-06T19:57:18+00:00","dateUpdated":null,"dateLastComment":"2020-05-06T20:18:16+00:00","insertUserID":121284,"insertUser":{"userID":121284,"name":"Jennifer Flanagan","url":"https:\/\/community.smartsheet.com\/profile\/Jennifer%20Flanagan","photoUrl":"https:\/\/lh3.googleusercontent.com\/-nsyfrj0LkpI\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucnuFKHgjCZOG6MquIJZGOafJQx2eA\/s96-c\/photo.jpg","dateLastActive":"2021-02-03T19:04:35+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-07-14T08:43:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":346,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/68099\/how-to-auto-trigger-a-flag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68099\/how-to-auto-trigger-a-flag","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":67851,"type":"question","name":"R,Y,G and G - Part 2","excerpt":"Hey @Paul Newcome \/ @Andrée Starå , Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request. . In a nutshell, at the parent level, I'd like the \"current health\" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is…","categoryID":322,"dateInserted":"2020-04-28T22:19:23+00:00","dateUpdated":null,"dateLastComment":"2020-05-06T19:43:18+00:00","insertUserID":120709,"insertUser":{"userID":120709,"name":"Dyon Martin","url":"https:\/\/community.smartsheet.com\/profile\/Dyon%20Martin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hb_X4fs89_w!nEtVv5cHCfo!mSFBH5T81RI","dateLastActive":"2020-11-12T19:36:48+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-07-14T08:43:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":85,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/67851\/r-y-g-and-g-part-2","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67851\/r-y-g-and-g-part-2","format":"rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-30T18:23:16+00:00","dateAnswered":"2020-04-29T12:18:15+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"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"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