日历

伊丽莎白Riebeling
伊丽莎白Riebeling ✭✭✭
在内容基本知识

你好!

我所在的公司计划中没有日历应用程序(至少目前没有)，所以有没有人可以分享他们在不使用日历应用程序的情况下显示假日员工的最佳日历技巧和技巧?

任何和所有的建议欢迎!

伊丽莎白是Smartsheet的头号粉丝

标签:
· 在Facebook上分享 在Twitter上分享

答案

  • GrahamWelsby
    GrahamWelsby ✭✭

    你好,伊丽莎白,

    很简单，我设置了一个网格，联系人列表，开始日期和结束日期。

    然后是一个供用户添加日期的表单，在Calendar视图中，只需确保设置为“日期范围”—开始日期和结束日期。

    自使用审批以来，我添加了一种添加部门经理以批准请求的方法，以及一个共享过滤器，仅显示已批准的假期。有点复杂，但可以相对快速地设置。

    希望这对你有帮助?


    格雷厄姆

    · 在Facebook上分享 在Twitter上分享
  • 伊丽莎白Riebeling
    伊丽莎白Riebeling ✭✭✭

    谢谢你！这就是我所拥有的(我使用了一个现有的模板)。我在一个新的部门，所以我不确定假期是否需要在提交之前得到批准。如果有的话，我一定会加的!

    · 在Facebook上分享 在Twitter上分享

类别

Might be you need to move the first )<\/p>

try this<\/p>

=INDEX(COLLECT({OPK Monthly Report 22-23 Unfilled 0-3}, {OPK Monthly Report 22-23 Month}, \"April\", {OPK Monthly Report 22-23 Grantee Name}, Grantee@row), 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106563,"type":"question","name":"Embed Smartsheet fields into Automation emails","excerpt":"It would be great if we could embed Smartsheet fields into the body of an automation email. For example, I have several emails going to different departments and if the auto email could be set-up like below, it would save time, clicks, confusion, etc.: <> has submitted a new request. The request…","categoryID":321,"dateInserted":"2023-06-16T18:25:31+00:00","dateUpdated":"2023-06-19T08:27:13+00:00","dateLastComment":"2023-06-16T18:54:24+00:00","insertUserID":156053,"insertUser":{"userID":156053,"name":"jl.furstenberg","url":"https:\/\/community.smartsheet.com\/profile\/jl.furstenberg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T18:52:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"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-19T09:36:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":1,"hot":3373883695,"url":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106563\/embed-smartsheet-fields-into-automation-emails","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106563,"commentID":381070,"name":"Re: Embed Smartsheet fields into Automation emails","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381070#Comment_381070","dateInserted":"2023-06-16T18:54:24+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-19T09:36:12+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T08:27:32+00:00","dateAnswered":"2023-06-16T18:49:50+00:00","acceptedAnswers":[{"commentID":381065,"body":"

Hi @jl.furstenberg<\/a> <\/p>

I hope you're well and safe!<\/p>

It's already possible with the Placeholder feature.<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2479256-customize-the-content-of-your-alerts-and-requests\n <\/a>\n<\/div>

Would that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic weekend!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":1},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]},{"discussionID":106543,"type":"question","name":"Automation and Email Recipient","excerpt":"Hello, Is the email notification through the automation criteria only available to recipients with Smartsheet accounts or to anyone whose email address was entered in the recipient field? Thank you.","categoryID":321,"dateInserted":"2023-06-16T03:56:51+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T04:30:53+00:00","insertUserID":162449,"insertUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162449,"lastUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":42,"score":null,"hot":3373778864,"url":"https:\/\/community.smartsheet.com\/discussion\/106543\/automation-and-email-recipient","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106543\/automation-and-email-recipient","format":"Rich","lastPost":{"discussionID":106543,"commentID":380961,"name":"Re: Automation and Email Recipient","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380961#Comment_380961","dateInserted":"2023-06-16T04:30:53+00:00","insertUserID":162449,"insertUser":{"userID":162449,"name":"CharMu","url":"https:\/\/community.smartsheet.com\/profile\/CharMu","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-16T04:56:20+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-16T04:29:02+00:00","dateAnswered":"2023-06-16T04:24:16+00:00","acceptedAnswers":[{"commentID":380960,"body":"

Hi,<\/p>


<\/p>

You can send notifications to any valid email address. If you're planning to send alerts or reminders with a link to the sheet, the user will not be able to click the link and access it if they do not have a Smartsheet account and not shared to the sheet.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5383,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 索引收集错误

    你好!我试图使用INDEX COLLECT函数来获取数值。月的总数过滤器在两个工作表之间匹配名称。这是我使用的公式，它返回一个不正确的参数集错误。=INDEX(COLLECT({OPK月报22-23未填写0-3}，{OPK月报…

  • 嵌入智能表字段到自动化电子邮件

    如果我们能将Smartsheet字段嵌入到自动化电子邮件的正文中，那就太好了。例如，我有几封发给不同部门的电子邮件，如果自动电子邮件可以像下面这样设置，它将节省时间，点击，混乱等:<>已经提交了一个新的请求。请求……

  • 自动化和电子邮件收件人

    您好，通过自动化标准发送的电子邮件通知是否仅对拥有Smartsheet帐户的收件人或在收件人字段中输入电子邮件地址的任何人可用?谢谢你！