Legal

\"Approved\", @cell <> \"Rejected\", @cell <> \"Withdrawn\")) However everything…","categoryID":322,"dateInserted":"2019-03-15T11:52:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T14:32:06+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-08-22T17:10:38+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers Alumni"},"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":91,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-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"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"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":43456,"type":"discussion","name":"NETDAYS based on IF statement","excerpt":"I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP\/CR]398, TODAY()) but I don't know how to work that into a…","categoryID":322,"dateInserted":"2019-03-13T11:13:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-13T14:18:44+00:00","insertUserID":81681,"insertUser":{"userID":81681,"name":"SD@HL","url":"https:\/\/community.smartsheet.com\/profile\/SD%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bBPX272FRz4!BFlXAbGyKbw!5CAD_Q514bi","dateLastActive":"2023-04-25T19:18:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":81681,"lastUser":{"userID":81681,"name":"SD@HL","url":"https:\/\/community.smartsheet.com\/profile\/SD%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bBPX272FRz4!BFlXAbGyKbw!5CAD_Q514bi","dateLastActive":"2023-04-25T19:18:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":463,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/43456\/netdays-based-on-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43456\/netdays-based-on-if-statement","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":274,"urlcode":"legal","name":"Legal"},{"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":43401,"type":"discussion","name":"Sumif WTheck?","excerpt":"Hello - I am trying to draft a formula to sum the column 9 but only when column 3 is \"John Smith\" and when column 11 is not equal to \"complete.\" I got this far, but can't figure this out: =SUMIF([Column9]:[Column9],Column3; column3, @cell=\"John Smith\")","categoryID":322,"dateInserted":"2019-03-12T15:26:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-12T16:09:10+00:00","insertUserID":81551,"insertUser":{"userID":81551,"name":"JH@HL","url":"https:\/\/community.smartsheet.com\/profile\/JH%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wk1Wt4GkMEQ!5YDXOW2yc2Y!ujlIRNX6ZR_","dateLastActive":"2021-12-10T20:34:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":81551,"lastUser":{"userID":81551,"name":"JH@HL","url":"https:\/\/community.smartsheet.com\/profile\/JH%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wk1Wt4GkMEQ!5YDXOW2yc2Y!ujlIRNX6ZR_","dateLastActive":"2021-12-10T20:34:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/43401\/sumif-wtheck","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43401\/sumif-wtheck","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":274,"urlcode":"legal","name":"Legal"},{"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":18501,"type":"discussion","name":"Salesforce ServiceCloud Users\/Connections","excerpt":"Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…","categoryID":321,"dateInserted":"2018-01-26T20:29:28+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-08T16:00:36+00:00","insertUserID":35966,"insertUser":{"userID":35966,"name":"Hinashah","url":"https:\/\/community.smartsheet.com\/profile\/Hinashah","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-01-29T15:47:17+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":81346,"lastUser":{"userID":81346,"name":"eric.meyer81346","url":"https:\/\/community.smartsheet.com\/profile\/eric.meyer81346","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pF9CaVaZqPw!gpFBn-LAu3o!iYvy2Exv3Uk","dateLastActive":"2020-06-05T15:24:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":142,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/18501\/salesforce-servicecloud-users-connections","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/18501\/salesforce-servicecloud-users-connections","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":249,"urlcode":"education","name":"Education"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"}],"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":41936,"type":"discussion","name":"Vertical Layout for Alerts","excerpt":"Is there a way for us to control\/customize the format of the alerts we receive between vertical or horizontal? We prefer the vertical formatting over the horizontal as it is easier to read and the formatting carries when we have to forward the email. I have several sheets where when I first set-up the alerts, they came in…","categoryID":321,"dateInserted":"2019-02-20T14:45:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-07T04:04:51+00:00","insertUserID":79251,"insertUser":{"userID":79251,"name":"Glenda K.D.","url":"https:\/\/community.smartsheet.com\/profile\/Glenda%20K.D.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-10T15:11:23+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":576,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/41936\/vertical-layout-for-alerts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41936\/vertical-layout-for-alerts","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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":19966,"type":"discussion","name":"COUNTIF between Dates","excerpt":"I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my current one. If it is not clear from the formula, I'm trying to count tasks assigned to…","categoryID":322,"dateInserted":"2018-02-21T11:01:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-26T13:38:24+00:00","insertUserID":30431,"insertUser":{"userID":30431,"name":"bsemingson30431","url":"https:\/\/community.smartsheet.com\/profile\/bsemingson30431","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-02-20T18:06:42+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":6,"countViews":595,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/19966\/countif-between-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/19966\/countif-between-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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"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":40856,"type":"discussion","name":"Multiple Selections from a Drop Down","excerpt":"Hi, am creating a smartsheet to collect certain client information & documents to provide a certain service. While creating a form which could be sent to my clients, I've realised that it only allows for a single selection of a document off all the documents that I've listed in the drop down. However I need multiple…","categoryID":321,"dateInserted":"2019-02-07T01:20:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-08T04:36:50+00:00","insertUserID":77616,"insertUser":{"userID":77616,"name":"Ankit Kochar","url":"https:\/\/community.smartsheet.com\/profile\/Ankit%20Kochar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-23T00:40: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":9,"countViews":391,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/40856\/multiple-selections-from-a-drop-down","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40856\/multiple-selections-from-a-drop-down","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":40751,"type":"discussion","name":"Security assessment fields for each project","excerpt":"Our security certification requires that we provide answers to several key security questions for every project (risk assessment, project justification, etc) and I was wondering what the best way to handle that in Smartsheet would be. They're not really tasks, since it's just several sentences for each that need to be…","categoryID":321,"dateInserted":"2019-02-06T11:50:15+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-02-06T12:59:44+00:00","insertUserID":77476,"insertUser":{"userID":77476,"name":"DanielleElise","url":"https:\/\/community.smartsheet.com\/profile\/DanielleElise","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-18T15:43:25+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":62,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/40751\/security-assessment-fields-for-each-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40751\/security-assessment-fields-for-each-project","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":273,"urlcode":"security","name":"Security"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"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":7237,"type":"discussion","name":"Formula for Parent, Child, and Non-parent\/child rows","excerpt":"I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent\/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…","categoryID":319,"dateInserted":"2017-02-08T13:58:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-29T15:51:30+00:00","insertUserID":10742,"insertUser":{"userID":10742,"name":"Lauren B","url":"https:\/\/community.smartsheet.com\/profile\/Lauren%20B","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/eb\/a5\/neba5744ddf2b6f504378c4783d9ce90f.jpg","dateLastActive":"2019-04-04T12:11:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":6199,"lastUser":{"userID":6199,"name":"Rob Hagan","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Hagan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5a\/36\/n5a3670842ff6152dc89438b8153da7c0.jpg","dateLastActive":"2022-12-06T19:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":2707,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/7237\/formula-for-parent-child-and-non-parent-child-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7237\/formula-for-parent-child-and-non-parent-child-rows","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/09\/88\/098813356bb7087d94b1bfd41aec5c7e.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"parentchildformula.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":38821,"type":"discussion","name":"Extracting all instances of a word from a text string and creating a list in a separate cell","excerpt":"Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…","categoryID":322,"dateInserted":"2019-01-11T00:01:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-17T06:43:55+00:00","insertUserID":72196,"insertUser":{"userID":72196,"name":"erober01","url":"https:\/\/community.smartsheet.com\/profile\/erober01","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-04-30T14:12:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":39511,"lastUser":{"userID":39511,"name":"eric.o","url":"https:\/\/community.smartsheet.com\/profile\/eric.o","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-11\/b4\/72\/nb47282e48b112cb30b474010a6cdfb22.jpg","dateLastActive":"2019-02-26T06:44:46+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":443,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/38821\/extracting-all-instances-of-a-word-from-a-text-string-and-creating-a-list-in-a-separate-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38821\/extracting-all-instances-of-a-word-from-a-text-string-and-creating-a-list-in-a-separate-cell","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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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}">