我可以将日历视图设置为打开今天的日期吗?
答案
-
桑杰·切鲁巴拉WPP ✭✭✭✭✭
我的经验是,日历视图的正常行为是打开到“今天”,即使有过去和未来的任务日期。你能提供任何额外的上下文吗?例如,这是启用了依赖项的项目计划,还是配置了开始-结束日期的简单表?
-
阿希利奥。 ✭✭✭✭✭
嗨,桑杰,
直到上周晚些时候,这一直是我们的典型经验。
这是一个只有一列日期的简单表格。每个日期都有多个条目,都在各自的行中。
当我切换到日历视图,我得到这个:
-
吉纳维芙P。 员工管理
只有在我的列中有2015年的日期时,我才能复制这一点。当我将所有日期都设置为2022年时,我甚至无法在日历视图中回滚到2021年:必须有一个具有更早日期的任务才能看到前一年。
有没有可能某个任务的日期写错了?如果在日历中看不到2015年8月或9月的任何任务,请检查是否对可能隐藏任务的工作表应用了过滤器。
欢呼,
吉纳维芙
-
阿希利奥。 ✭✭✭✭✭
谢谢,吉纳维芙!不知道发生了什么,但现在已经修好了。可能只是一些奇怪的故障。我很感谢你帮我解决这个问题。看起来我们现在都准备好了:)
-
吉纳维芙P。 员工管理
没问题!我很高兴你又成功了。
类别
@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":"
If you want the parent to be yellow if there are no reds, but at least one yellow:<\/p>
Examples, with the first formula in Health column, second in Health2:<\/p>