法律

is not today; whereas in the Conditional Formatting dialog, we don't…","categoryID":321,"dateInserted":"2019-11-21T01:22:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-21T02:27:46+00:00","insertUserID":101121,"insertUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45:22+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-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":73,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/63536\/inconsistent-date-options","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63536\/inconsistent-date-options","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/e3\/2c\/e32c8d805e59090b4d57fa072695fe9b.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Date is NOT Today (Available)_0.PNG"},"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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":62831,"type":"discussion","name":"Auto-Lock All the Child Rows","excerpt":"Hi All I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanism. Thanks in advance! Nasir","categoryID":322,"dateInserted":"2019-11-14T00:15:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-14T04:06:34+00:00","insertUserID":101121,"insertUser":{"userID":101121,"name":"Nasir@EBC","url":"https:\/\/community.smartsheet.com\/profile\/Nasir%40EBC","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!BXjVgasCKqQ!c2DUpw9M-nY!rKVmGGpiJ0x","dateLastActive":"2023-03-08T10:45:22+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-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":196,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/62831\/auto-lock-all-the-child-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62831\/auto-lock-all-the-child-rows","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":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"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":62551,"type":"discussion","name":"Project Approval Received \/ Master Project Sheet Populated","excerpt":"I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review\/approval\/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…","categoryID":322,"dateInserted":"2019-11-11T23:06:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-12T08:58:59+00:00","insertUserID":77966,"insertUser":{"userID":77966,"name":"Brad Huff","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Huff","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAleYfQQJzo!kmdcH1B4cjw!ieS0yJrcV6Q","dateLastActive":"2020-01-16T19:22:42+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-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":186,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/62551\/project-approval-received-master-project-sheet-populated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62551\/project-approval-received-master-project-sheet-populated","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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"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":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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":446,"urlcode":"update-requests","name":"Update Requests"},{"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":61511,"type":"discussion","name":"If Formula","excerpt":"Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it. I have a column that is Date of Last Correspondence, Days till follow-up, Next Follow up Date is the column that I want to auto…","categoryID":322,"dateInserted":"2019-10-29T18:26:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-30T08:46:18+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-06-06T17:54:35+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"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-06-10T20:34:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":66,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/61511\/if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61511\/if-formula","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/c5\/08\/c50837cc3125c04196ef61bc836f64fb.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"If Days.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"},{"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":61386,"type":"discussion","name":"Automation from a form submission","excerpt":"Hi I have created a form that is working perfectly in that once completed it is populating the sheet data. I have also created a number of automation work flows that work if you directly input into the sheet but do not appear to work if the data is entered via the form - please can anyone advise if I have missed a step or…","categoryID":321,"dateInserted":"2019-10-29T08:55:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-29T09:33:30+00:00","insertUserID":91596,"insertUser":{"userID":91596,"name":"Digit","url":"https:\/\/community.smartsheet.com\/profile\/Digit","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-20T09:27:52+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-06-10T23:30:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":218,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/61386\/automation-from-a-form-submission","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/61386\/automation-from-a-form-submission","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":274,"urlcode":"Legal","name":"Legal"},{"tagID":300,"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":60476,"type":"discussion","name":"Automation - Request Update","excerpt":"Hi. I'm looking for help troubleshooting an issue I\"m having with Automation in smartsheet. I set up a recurring request for updates to run each Friday at 8:00 AM PST to all Assigned To users in the sheet. The problem I'm having is my request automatically includes a form I created for project intake. I do not want the…","categoryID":321,"dateInserted":"2019-10-17T13:26:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-10-19T14:17:48+00:00","insertUserID":107936,"insertUser":{"userID":107936,"name":"Sandra Dye","url":"https:\/\/community.smartsheet.com\/profile\/Sandra%20Dye","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/a9\/ea\/na9ea590a669b6e905afe9f694638eaea.jpg","dateLastActive":"2021-04-27T21:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4246,"lastUser":{"userID":4246,"name":"Scott Willeke","url":"https:\/\/community.smartsheet.com\/profile\/Scott%20Willeke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/85\/61\/n85610af0b3a27a205f0401e575349e76.jpg","dateLastActive":"2021-10-11T20:00:26+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":204,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/60476\/automation-request-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60476\/automation-request-update","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/f5\/3c\/f53c34c868a89e8682671950d810cee1.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"UpdateRequestCapture.PNG"},"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":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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}">