日历在望
有没有一种方法可以在显示器上显示日历?我想用视觉为我们部门创建一个主页，如果我能添加一个即将发生的事件的日历，让它看起来像一个日历，那就太好了。我可以使用报表，但它不会显示在日历视图中。
评论
-
布伦特内森 ✭
在sight中没有对日历的本机支持。以下是我脑海中浮现的一些选择....
选项1:设置一个伪日历表，然后制作一个报告，将其作为一个小部件显示在您的视线中。
选项2:为每个月的每一天制作一个小部件。每个小部件都可以链接到不同的来源，当点击显示当天发生了什么。不过，设置和维护它会有点乏味
-
朱迪·马塔 ✭✭
是啊，我想到报告的主意了。但即使你的报告在日历视图中，它也会显示为网格，这很好，但它没有给出我希望的视觉效果。
-
布兰登伯格 ✭✭✭ -
布伦特内森 ✭
所以我能够使用度量小部件来实现这一点，如果你想的话，它还会根据工作表中的条件格式更新颜色。不幸的是，您需要每个月构建一个。它也支持小文本输入，而不需要改变小部件的大小。
-
布兰登伯格 ✭✭✭
谢谢!做得很好。它开始变得越来越明显，什么颜色与活动类别对齐，但只是想要一个关键作为一个很好的指导。这是我日历的快照。
--
布兰登伯格
高级项目经理/业务运营
类别
=[Completed Date]@row - (WEEKDAY([Completed Date]@row) - 2)+7<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":106620,"type":"question","name":"Need empty column blank","excerpt":"I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank. =([CONFIRM OW PHOTO DUE]@row + 14) Need the \"14\" left blank","categoryID":322,"dateInserted":"2023-06-20T00:19:06+00:00","dateUpdated":null,"dateLastComment":"2023-06-20T14:11:32+00:00","insertUserID":162246,"insertUser":{"userID":162246,"name":"Shawn_K2","url":"https:\/\/community.smartsheet.com\/profile\/Shawn_K2","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nPFlXyflhuI!uj8vZ9JIm_o!1axowkoO9t8","dateLastActive":"2023-06-20T14:32:08+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-20T15:01:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":61,"score":null,"hot":3374494238,"url":"https:\/\/community.smartsheet.com\/discussion\/106620\/need-empty-column-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106620\/need-empty-column-blank","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106620,"commentID":381293,"name":"Re: Need empty column blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381293#Comment_381293","dateInserted":"2023-06-20T14:11:32+00:00","insertUserID":8888,"insertUser":{"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-20T15:01:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BW38GVCJFDPD\/2023-06-19-20-16-43-creative-ops-comprehensive-content-tracker-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-06-19 20_16_43-Creative Ops - Comprehensive Content Tracker - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-20T13:11:28+00:00","dateAnswered":"2023-06-20T12:13:43+00:00","acceptedAnswers":[{"commentID":381259,"body":"
=If([Confirm OW Photo Due]@row=\"//www.santa-greenland.com/community/discussion/7643/\",\"//www.santa-greenland.com/community/discussion/7643/\",[Confirm OW Photo Due]@row+14)<\/p>"},{"commentID":381278,"body":"
Hi @Shawn_K2<\/a> <\/p>
