我可以将日历视图设置为打开今天的日期吗?

你好,

上周,我们注意到我们的日历视图打开到几年前的某个日期(2015年8月),而不是打开到今天的日期(它在2021年全年都成功地做到了这一点)。此表格于2021年完成,因此没有在创建日期之前输入的日期。

我改变了甘特视图中的设置,打开到今天的日期,它在日历中不一样。

现在我们遇到了这个问题,有办法更新设置吗?

我们使用日历来共享日程安排,我不能要求每个人滚动6年才能到达当前日期。

谢谢你!

阿希利

答案

@AshleyDeichmueller<\/a> glad you got it partially working! also just FYI you would need every source sheet to be formatted the same, just confirming you have done that as well.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 16:43:34","updateUser":{"userID":157151,"name":"AshleyDeichmueller","url":"https:\/\/community.smartsheet.com\/profile\/AshleyDeichmueller","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!yVdp8nPf8bs!Aj8oR9fpO_s!7MuMrhnDdUp","dateLastActive":"2023-01-20T16:43:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"}]},{"discussionID":99909,"type":"question","name":"Overall Project Health (Parent Row) Formula based on Children Rows","excerpt":"Hello! I am currently using this formula to visual task health. =IF(OR(Status@row = \"Complete\", Status@row = \"Done\", Status@row = \"Approved\"), \"Green\", IF([Due Date]@row <= TODAY(), \"Red\", IF([Due Date]@row <= TODAY(7), \"Yellow\", IF([Due Date]@row > TODAY(), \"Green\")))) The tasks are nestled under a parent row for a given…","categoryID":321,"dateInserted":"2023-01-19T18:40:28+00:00","dateUpdated":null,"dateLastComment":"2023-01-20T16:44:38+00:00","insertUserID":151614,"insertUser":{"userID":151614,"name":"Hannah Gray","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20Gray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uuNQt4Dnmbs!bLtR2wDcTTs!1kcrQ2FCXER","dateLastActive":"2023-01-20T16:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151614,"lastUser":{"userID":151614,"name":"Hannah Gray","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20Gray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uuNQt4Dnmbs!bLtR2wDcTTs!1kcrQ2FCXER","dateLastActive":"2023-01-20T16:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":12,"score":null,"hot":3348387906,"url":"https:\/\/community.smartsheet.com\/discussion\/99909\/overall-project-health-parent-row-formula-based-on-children-rows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99909\/overall-project-health-parent-row-formula-based-on-children-rows","format":"Rich","lastPost":{"discussionID":99909,"commentID":358006,"name":"Re: Overall Project Health (Parent Row) Formula based on Children Rows","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/358006#Comment_358006","dateInserted":"2023-01-20T16:44:38+00:00","insertUserID":151614,"insertUser":{"userID":151614,"name":"Hannah Gray","url":"https:\/\/community.smartsheet.com\/profile\/Hannah%20Gray","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uuNQt4Dnmbs!bLtR2wDcTTs!1kcrQ2FCXER","dateLastActive":"2023-01-20T16:44:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/UUTSD9FSL13M\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-20T18:22:37+00:00","dateAnswered":"2023-01-20T12:51:00+00:00","acceptedAnswers":[{"commentID":357962,"body":"

Hi @Hannah Gray<\/a>,<\/p>

This is doable - if you only want the parent to be red if any of the children are, but green otherwise then this column formula in Health should work:<\/p>

=IF(COUNTIF(CHILDREN([Health]@row), \"Red\") > 0, \"Red\", IF(COUNTIF(CHILDREN([Health]@row), \"Green\") > 0, \"Green\", IF(OR(Status@row = \"Complete\", Status@row = \"Done\", Status@row = \"Approved\"), \"Green\", IF([Due Date]@row <= TODAY(), \"Red\", IF([Due Date]@row <= TODAY(7), \"Yellow\", IF([Due Date]@row >= TODAY(), \"Green\")))))).<\/p>

If you want the parent to be yellow if there are no reds, but at least one yellow:<\/p>

=IF(COUNTIF(CHILDREN(Health@row), \"Red\") > 0, \"Red\", IF(COUNTIF(CHILDREN(Health@row), \"Yellow\") > 0, \"Yellow\", IF(COUNTIF(CHILDREN(Health@row), \"Green\") > 0, \"Green\", IF(OR(Status@row = \"Complete\", Status@row = \"Done\", Status@row = \"Approved\"), \"Green\", IF([Due Date]@row <= TODAY(), \"Red\", IF([Due Date]@row <= TODAY(7), \"Yellow\", IF([Due Date]@row >= TODAY(), \"Green\")))))))<\/p>

Examples, with the first formula in Health column, second in Health2:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

With a red status added:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Hope this helps - if you have any problems or questions with this let us know. 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-20 18:22:37","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-01-20T19:01:56+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"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}],"tags":[]},{"discussionID":99892,"type":"question","name":"Approve \/ Decline Comment Option","excerpt":"I have a created an approval request in a workflow and am unable to see how to add the option for the approver\/decliner to enter a comment when approving\/declining?","categoryID":321,"dateInserted":"2023-01-19T16:25:44+00:00","dateUpdated":null,"dateLastComment":"2023-01-19T19:48:51+00:00","insertUserID":140974,"insertUser":{"userID":140974,"name":"Lisa Welch","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20Welch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-01-19T22:07:55+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\/518\/n0UL39EAWX965.jpg","dateLastActive":"2023-01-19T19:48:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":38,"score":null,"hot":3348305675,"url":"https:\/\/community.smartsheet.com\/discussion\/99892\/approve-decline-comment-option","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99892\/approve-decline-comment-option","format":"Rich","lastPost":{"discussionID":99892,"commentID":357883,"name":"Re: Approve \/ Decline Comment Option","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357883#Comment_357883","dateInserted":"2023-01-19T19:48:51+00:00","insertUserID":11072,"insertUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/518\/n0UL39EAWX965.jpg","dateLastActive":"2023-01-19T19:48:21+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/HDAN1QVGR1W2\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-01-19T17:46:49+00:00","dateAnswered":"2023-01-19T16:42:44+00:00","acceptedAnswers":[{"commentID":357801,"body":"

In my test, I added the comment column to the request process, so when the user was sent the message to approve or decline, the comments field was available there... You can see on my sample setup I include the field in the request approval section. Then on the resulting email, there is a comment field so the commenter can add comments too. <\/p>