每个星期一自动到期日期
丽莎Vercellone
✭✭
我有几份报告要写。我有一个SmartSheet,上面列出了它运行的频率(每天、每周或每月)。我有一个基于完成日期计算下一个截止日期的方程。当我完成报告时,完成日期会自动记录下来。它运行得很好,除了每周报告由于某种原因没有在周一运行的时候。无论我何时完成周报,我都希望它将下一个截止日期设置为下周一,除非是假日。目前,它只是将下一个截止日期设置为完成日期后的一周。
我有几个自动化记录状态更改日期,然后将其重置和操作状态为空白,以便它从当前到期日滚动到报告的下一个到期日。
关于如何做到这一点有什么想法吗?
这是我现在的方程:
=如果((电子邮件保护)= "Daily", WORKDAY([Completed Date]@row, 1, Holidays:节假日),IF((电子邮件保护)= "weekly", WORKDAY([已完成日期]@row, 5,假日:假日),IF((电子邮件保护)= "Monthly", WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1,1), 1, Holidays:Holidays))))
谢谢,丽莎
最佳答案
-
Hollie绿色 ✭✭✭✭✭
将下面的公式合并到你的公式中,它会给出最后一个完成日期之后的星期一。
=[已完成日期]@row -(工作日([已完成日期]@row) - 2)+7
答案
-
Hollie绿色 ✭✭✭✭✭
将下面的公式合并到你的公式中,它会给出最后一个完成日期之后的星期一。
=[已完成日期]@row -(工作日([已完成日期]@row) - 2)+7
-
丽莎Vercellone ✭✭
谢谢你!我花了一段时间才弄明白这个等式是如何以及为什么成立的!我知道一定有一种我没想到的简单方法。
帮助文章参考资料欧宝体育app官方888
TODAY(), Fleet:Fleet, \"A220\")","categoryID":322,"dateInserted":"2023-06-21T16:14:49+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T20:20:41+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162138,"lastUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":38,"score":null,"hot":3374745330,"url":"https:\/\/community.smartsheet.com\/discussion\/106707\/how-to-count-how-many-interviews-in-the-current-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106707\/how-to-count-how-many-interviews-in-the-current-week","format":"Rich","lastPost":{"discussionID":106707,"commentID":381628,"name":"Re: How to count how many interviews in the current week?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381628#Comment_381628","dateInserted":"2023-06-21T20:20:41+00:00","insertUserID":162138,"insertUser":{"userID":162138,"name":"Louis.Smith","url":"https:\/\/community.smartsheet.com\/profile\/Louis.Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:28:23+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\/TNZRUD6K3A2N\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T20:21:04+00:00","dateAnswered":"2023-06-21T19:39:48+00:00","acceptedAnswers":[{"commentID":381601,"body":"