日程表视图

\"Complete\", [Target End Date]301 <= TODAY()), 1, 0) Currently, the column flags…","categoryID":322,"dateInserted":"2020-06-22T21:01:38+00:00","dateUpdated":null,"dateLastComment":"2021-02-03T16:58:05+00:00","insertUserID":122907,"insertUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122907,"lastUser":{"userID":122907,"name":"Titilope Akinlose","url":"https:\/\/community.smartsheet.com\/profile\/Titilope%20Akinlose","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-03T16:53:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":363,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69311\/smartsheet-at-risk-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/MQCFRTESBHS0\/annotation-2020-06-22-165725.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Annotation 2020-06-22 165725.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-23T17:54:44+00:00","dateAnswered":"2020-06-23T12:43:18+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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":75317,"type":"question","name":"Setting up access to a Smartsheet Calendar in Outlook","excerpt":"We are migrating our vacation and PTO requests into a Smartsheet. We would like the calendar view that our payroll admin has of all the approved time off to be available for all to see in outlook. I took the webcal link and shared it with several staff members to see if they could access the calendar. It looks like it…","categoryID":321,"dateInserted":"2021-01-26T19:42:59+00:00","dateUpdated":null,"dateLastComment":"2021-01-29T17:34:58+00:00","insertUserID":12169,"insertUser":{"userID":12169,"name":"Anna1","url":"https:\/\/community.smartsheet.com\/profile\/Anna1","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-05\/e3\/26\/ne326d790c4ac6d906d7a3c9d2fcc2879.jpg","dateLastActive":"2021-05-18T14:48:19+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-06-23T18:55:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":305,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/75317\/setting-up-access-to-a-smartsheet-calendar-in-outlook","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75317\/setting-up-access-to-a-smartsheet-calendar-in-outlook","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-01-29T17:34:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"}],"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":75387,"type":"question","name":"How can I keep the colors in the calendar app view from changing when data is changed?","excerpt":"I built a calendar view from a report (no pre-selected colors assigned), which has primary and secondary grouping. The colors assigned were fine, however whenever the in-line data was changed through the detail view that pops up when you click on a calendar bar, all the colors for the entire view would change to other…","categoryID":321,"dateInserted":"2021-01-27T19:55:58+00:00","dateUpdated":null,"dateLastComment":"2021-01-28T15:10:46+00:00","insertUserID":61856,"insertUser":{"userID":61856,"name":"Rick_Bailey","url":"https:\/\/community.smartsheet.com\/profile\/Rick_Bailey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2TDbviwwsOY!BJDbwSweK-Y!jM39tdK4xhS","dateLastActive":"2023-06-22T20:46:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":61856,"lastUser":{"userID":61856,"name":"Rick_Bailey","url":"https:\/\/community.smartsheet.com\/profile\/Rick_Bailey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!2TDbviwwsOY!BJDbwSweK-Y!jM39tdK4xhS","dateLastActive":"2023-06-22T20:46:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":80,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/75387\/how-can-i-keep-the-colors-in-the-calendar-app-view-from-changing-when-data-is-changed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75387\/how-can-i-keep-the-colors-in-the-calendar-app-view-from-changing-when-data-is-changed","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-01-28T15:10:46+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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":75226,"type":"question","name":"Calendar as default view when shared in Teams tab","excerpt":"Is there a way to ensure a Smartsheet imported to Teams always displays in Calendar view? I think I have been able to save this view as the default in Smartsheet itself, but when I open the sheet's tab in Teams it displays as grid view. I signed out of Teams and signed back in to check whether the changes just needed to go…","categoryID":321,"dateInserted":"2021-01-25T12:20:56+00:00","dateUpdated":null,"dateLastComment":"2021-01-28T10:32:55+00:00","insertUserID":131072,"insertUser":{"userID":131072,"name":"Emma Slawinski","url":"https:\/\/community.smartsheet.com\/profile\/Emma%20Slawinski","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-12T20:04:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":131072,"lastUser":{"userID":131072,"name":"Emma Slawinski","url":"https:\/\/community.smartsheet.com\/profile\/Emma%20Slawinski","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-12T20:04:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":241,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/75226\/calendar-as-default-view-when-shared-in-teams-tab","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75226\/calendar-as-default-view-when-shared-in-teams-tab","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-27T15:24:54+00:00","dateAnswered":"2021-01-27T15:17:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"}],"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":68979,"type":"question","name":"Change the color of Task Bars in Calendar View","excerpt":"I would like to change the color of task bars in calendar view. I understand I can right click and change these one by one, but I would like them to change automatically. I have tried manually changing the rows in Grid View to reflect the color I want the task bars to be in Calendar View with no luck. I also used…","categoryID":321,"dateInserted":"2020-06-09T14:51:23+00:00","dateUpdated":null,"dateLastComment":"2021-01-21T16:00:35+00:00","insertUserID":85566,"insertUser":{"userID":85566,"name":"M. David","title":"","url":"https:\/\/community.smartsheet.com\/profile\/M.%20David","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-13T03:30:57+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-06-23T18:55:49+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":687,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/68979\/change-the-color-of-task-bars-in-calendar-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68979\/change-the-color-of-task-bars-in-calendar-view","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-09T15:08:48+00:00","dateAnswered":"2020-06-09T15:01:59+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"}],"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":75083,"type":"question","name":"Options to show multiple project plan sheets into one view","excerpt":"I currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Has anyone tried to do this before?","categoryID":321,"dateInserted":"2021-01-21T00:49:21+00:00","dateUpdated":null,"dateLastComment":"2021-01-21T05:04:05+00:00","insertUserID":130622,"insertUser":{"userID":130622,"name":"tim_kuykendall@dell.com","url":"https:\/\/community.smartsheet.com\/profile\/tim_kuykendall%40dell.com","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DQlXgyW2zro!wvjX9wmMNjQ!OkRyfq7FEfX","dateLastActive":"2021-02-09T18:43:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":130622,"lastUser":{"userID":130622,"name":"tim_kuykendall@dell.com","url":"https:\/\/community.smartsheet.com\/profile\/tim_kuykendall%40dell.com","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!DQlXgyW2zro!wvjX9wmMNjQ!OkRyfq7FEfX","dateLastActive":"2021-02-09T18:43:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":237,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/75083\/options-to-show-multiple-project-plan-sheets-into-one-view","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75083\/options-to-show-multiple-project-plan-sheets-into-one-view","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-21T05:03:41+00:00","dateAnswered":"2021-01-21T02:25:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"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":74581,"type":"question","name":"How to hide columns in callenderview","excerpt":"Inside a Report i can choice what columns i want to show in the grid and gantt view, however if i switch to callenderview and selected a project it shows everything. is there a possiblity its only shows the choisen columns.","categoryID":321,"dateInserted":"2021-01-07T10:02:04+00:00","dateUpdated":null,"dateLastComment":"2021-01-07T13:25:51+00:00","insertUserID":130386,"insertUser":{"userID":130386,"name":"Ruben Luyten","url":"https:\/\/community.smartsheet.com\/profile\/Ruben%20Luyten","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-26T14:40:58+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-24T00:50:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":151,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/74581\/how-to-hide-columns-in-callenderview","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/74581\/how-to-hide-columns-in-callenderview","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-07T13:29:28+00:00","dateAnswered":"2021-01-07T13:25:51+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"}],"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}">