Formulas

9 \/ 30 \/ 18,\"3Q 18\",\"4Q 18\",)))) Thanks a lot in…","categoryID":322,"dateInserted":"2018-07-06T04:08:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-06T11:12:40+00:00","insertUserID":10696,"insertUser":{"userID":10696,"name":"MARIE CHRISTINE ANNIC GUYOMARC'H","url":"https:\/\/community.smartsheet.com\/profile\/MARIE%20CHRISTINE%20ANNIC%20GUYOMARC%27H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/11\/40\/n114056ca0268543cf292bd714818353b.jpg","dateLastActive":"2018-07-06T03:55:36+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":2,"countViews":494,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/28091\/if-formula-with-condition-on-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28091\/if-formula-with-condition-on-dates","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":207,"urlcode":"sales","name":"Sales"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":28046,"type":"discussion","name":"Pre Populated Form Fields","excerpt":"I want to create an order request form with an inventory control sheet I've created. The sheet contains remaining stock on hand of several different items. The drop down list will contain the items I have in stock, but I'd like to have the amount available to show up based on the item selected. This number would be…","categoryID":322,"dateInserted":"2018-07-04T15:09:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-06T09:22:48+00:00","insertUserID":1557,"insertUser":{"userID":1557,"name":"Mike Couture","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Couture","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/b5\/0d\/nb50daf3eab872042e3b0f6b1299f275a.jpg","dateLastActive":"2018-07-04T13:43:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":1557,"lastUser":{"userID":1557,"name":"Mike Couture","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Couture","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/b5\/0d\/nb50daf3eab872042e3b0f6b1299f275a.jpg","dateLastActive":"2018-07-04T13:43:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":145,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/28046\/pre-populated-form-fields","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28046\/pre-populated-form-fields","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":204,"urlcode":"forms","name":"Forms"},{"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":27986,"type":"discussion","name":"not able to paste to the column with ID number","excerpt":"hi, I have removed a number of rows from my smartsheet. now I want to paste the data from another sheet but the system would not allow me to paste to the column with the doc ID number which fills in automatically. I would like to keep the original ID numbers therefore I would like to paste them from another sheet. What can…","categoryID":322,"dateInserted":"2018-07-03T07:14:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-05T08:50:46+00:00","insertUserID":48246,"insertUser":{"userID":48246,"name":"Anna Dukaczewska","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Dukaczewska","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-03T07:08:17+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":44281,"lastUser":{"userID":44281,"name":"Robin H","url":"https:\/\/community.smartsheet.com\/profile\/Robin%20H","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-26T15:01:37+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\/27986\/not-able-to-paste-to-the-column-with-id-number","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27986\/not-able-to-paste-to-the-column-with-id-number","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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"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":28016,"type":"discussion","name":"RYG Ball automation based on end date and status","excerpt":"I am trying to automate RYG balls based on both the end date [End Date] and status [Complete]. I am using RYG balls for the [Status] column and Harvey Balls for the [Complete] column. If [end date] is in the past and [Complete] is \"full\", turn rgy green If [end date] is in the past and [Complete] is either \"empty\",…","categoryID":322,"dateInserted":"2018-07-03T16:53:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-04T02:37:40+00:00","insertUserID":53361,"insertUser":{"userID":53361,"name":"lisa.bradley","url":"https:\/\/community.smartsheet.com\/profile\/lisa.bradley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-26T16:33:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":40116,"lastUser":{"userID":40116,"name":"p_bureau","url":"https:\/\/community.smartsheet.com\/profile\/p_bureau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-25T02:46:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":153,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/28016\/ryg-ball-automation-based-on-end-date-and-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28016\/ryg-ball-automation-based-on-end-date-and-status","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":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":27991,"type":"discussion","name":"VLOOKUP misalignment with column sort","excerpt":"hi, I have found misalignment of the data sort expectations between VLOOKUP function and Smartsheet's Column sort capability. It seems that when Column is being sorted, underscore symbol \"_\" is being put ahead of the letters, while when VLOOKUP is looking for the cell to match, it does expect \"_\" to be after the letters.…","categoryID":322,"dateInserted":"2018-07-03T09:19:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-04T01:18:59+00:00","insertUserID":53306,"insertUser":{"userID":53306,"name":"Vladimirs","url":"https:\/\/community.smartsheet.com\/profile\/Vladimirs","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-03T09:12:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":53306,"lastUser":{"userID":53306,"name":"Vladimirs","url":"https:\/\/community.smartsheet.com\/profile\/Vladimirs","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-03T09:12:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":249,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/27991\/vlookup-misalignment-with-column-sort","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27991\/vlookup-misalignment-with-column-sort","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-07\/0b\/98\/0b985ed916e6128a7319be30517c6903.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-07-03 at 14.18.25.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":27841,"type":"discussion","name":"Copying formula across columns","excerpt":"Hi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMIF(Personnel:Personnel, \"Alison Michel\", [Summer 2018 - Aug]:[Summer 2018 - Aug]) to…","categoryID":322,"dateInserted":"2018-06-29T12:53:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-03T12:41:24+00:00","insertUserID":36186,"insertUser":{"userID":36186,"name":"AMichel","url":"https:\/\/community.smartsheet.com\/profile\/AMichel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-29T12:41:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":153,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/27841\/copying-formula-across-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27841\/copying-formula-across-columns","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":27946,"type":"discussion","name":"Auto populate Assigned to based on reference","excerpt":"We have a project plan template and populate the 'assigned to' column with the role\/title. Once I copy the new project plan template, how could I automatically update the 'assigned to' by task based on a role\/name mapping. Could I have a project resources sheet with role and name and have the Project Plan tasks 'assigned…","categoryID":322,"dateInserted":"2018-07-02T13:49:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-03T10:58:38+00:00","insertUserID":52911,"insertUser":{"userID":52911,"name":"rlakin52911","url":"https:\/\/community.smartsheet.com\/profile\/rlakin52911","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-06\/5d\/f7\/n5df7bc519e12f1f8a3478f599d4fda94.jpg","dateLastActive":"2023-07-26T17:47:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":40116,"lastUser":{"userID":40116,"name":"p_bureau","url":"https:\/\/community.smartsheet.com\/profile\/p_bureau","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-09-25T02:46:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":140,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/27946\/auto-populate-assigned-to-based-on-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27946\/auto-populate-assigned-to-based-on-reference","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":24946,"type":"discussion","name":"Help with my formula","excerpt":"I am not the best at formulas and need some help. I cant seem to get my head around building formulas. Anyway can someone help please. I am trying to build a formula that will count all the true BOOLEAN in the children row and when it is greater than 4 return the a true outcome to the parent row. Hoopefully someone can…","categoryID":322,"dateInserted":"2018-05-08T23:50:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-02T23:31:30+00:00","insertUserID":47451,"insertUser":{"userID":47451,"name":"SharonR","url":"https:\/\/community.smartsheet.com\/profile\/SharonR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/351\/nDJO0BF72ICTY.JPG","dateLastActive":"2023-04-11T22:49:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":47451,"lastUser":{"userID":47451,"name":"SharonR","url":"https:\/\/community.smartsheet.com\/profile\/SharonR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/351\/nDJO0BF72ICTY.JPG","dateLastActive":"2023-04-11T22:49:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":53,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/24946\/help-with-my-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/24946\/help-with-my-formula","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":27816,"type":"discussion","name":"\"If clause\" in Dependancies","excerpt":"Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a \"yes\/no\" question. If yes, then sheet 3 needs to be completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!","categoryID":322,"dateInserted":"2018-06-29T09:06:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-02T13:52:49+00:00","insertUserID":53051,"insertUser":{"userID":53051,"name":"Jose da Silva","url":"https:\/\/community.smartsheet.com\/profile\/Jose%20da%20Silva","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-12T08:13:54+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":2,"countViews":52,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/27816\/if-clause-in-dependancies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27816\/if-clause-in-dependancies","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":219,"urlcode":"sheets","name":"Sheets"},{"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":27676,"type":"discussion","name":"RYG Ball Automation","excerpt":"Hello Community, How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do it manually each time I change the status of an individual cell. Thanks!","categoryID":322,"dateInserted":"2018-06-27T13:42:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-07-02T12:01:56+00:00","insertUserID":52781,"insertUser":{"userID":52781,"name":"dyep","url":"https:\/\/community.smartsheet.com\/profile\/dyep","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-31T13:38:16+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":52,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/27676\/ryg-ball-automation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27676\/ryg-ball-automation","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-06\/3d\/4f\/3d4f9d5f985b56c06066cceaf2a9100a.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"sspic1.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":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}">