政府
讨论表
90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!","categoryID":318,"dateInserted":"2016-07-06T14:06:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-07T13:11:02+00:00","insertUserID":5684,"insertUser":{"userID":5684,"name":"Rush Austin","url":"https:\/\/community.smartsheet.com\/profile\/Rush%20Austin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-07-06T14:02:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/5428\/date-driven-row-roll-off","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5428\/date-driven-row-roll-off","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":5379,"type":"discussion","name":"Average Children Rows with RYG","excerpt":"Hi all. I'm attempting to calculate an average for RYG balls in the parent row. I have gotten to the point of calculating all of my colors, but I'm not sure how to get the average. Here is my calculation thus far: =AVG(COUNTIF(CHILDREN(), \"Green\") + COUNTIF(CHILDREN(), \"Yellow\") * 2 + COUNTIF(CHILDREN(), \"Red\") * 3) This…","categoryID":318,"dateInserted":"2016-06-30T16:16:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-05T10:27:24+00:00","insertUserID":7105,"insertUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":7105,"lastUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":305,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5379\/average-children-rows-with-ryg","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5379\/average-children-rows-with-ryg","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":263,"urlcode":"Government","name":"Government"},{"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":5367,"type":"discussion","name":"Error in creating new Smartsheet from Google Drive","excerpt":"Anyone see this or know how to get around this? I could not find anything related to this problem. I have successfully installed the Smartsheet app to Chrome from the Chrome Web Store. I do New->More->Smartsheet. I get past the \"Your domain administrator has approved access to Smartsheet\" . Then, I see the error message,…","categoryID":318,"dateInserted":"2016-06-29T16:52:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-07-05T08:02:18+00:00","insertUserID":6705,"insertUser":{"userID":6705,"name":"FeliciaLabs","url":"https:\/\/community.smartsheet.com\/profile\/FeliciaLabs","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-17T20:32:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5367\/error-in-creating-new-smartsheet-from-google-drive","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5367\/error-in-creating-new-smartsheet-from-google-drive","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":5286,"type":"discussion","name":"Enhancement Request: Batch Updating in App","excerpt":"Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a \"batch update\" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…","categoryID":318,"dateInserted":"2016-06-22T17:07:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-06-24T09:09:37+00:00","insertUserID":7116,"insertUser":{"userID":7116,"name":"Tin Tran","url":"https:\/\/community.smartsheet.com\/profile\/Tin%20Tran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-06-24T09:32:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":93,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5286\/enhancement-request-batch-updating-in-app","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5286\/enhancement-request-batch-updating-in-app","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":5112,"type":"discussion","name":"i am trying to set up an It Service Request Tracker - Need workflow approval","excerpt":"Ii am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. Can that be done?","categoryID":318,"dateInserted":"2016-05-26T17:58:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-06-01T16:44:09+00:00","insertUserID":6826,"insertUser":{"userID":6826,"name":"Lisa Barnett","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Barnett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-26T17:54:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5171,"lastUser":{"userID":5171,"name":"Jennifer Dewhurst","url":"https:\/\/community.smartsheet.com\/profile\/Jennifer%20Dewhurst","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/0a\/ba\/n0aba031bda16bb3d2fae52f573d0d2e6.jpg","dateLastActive":"2021-08-30T21:47:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5112\/i-am-trying-to-set-up-an-it-service-request-tracker-need-workflow-approval","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5112\/i-am-trying-to-set-up-an-it-service-request-tracker-need-workflow-approval","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">