欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论，你想找到(或创建)一个更最新的版本，请访问当前论坛。

提前日期(滚动)

linda.miller16961
linda.miller16961 ✭
编辑12/09/19 在2017年发布的文章

我有一些经常重复出现的简单任务。是否有一种简单的方法可以按月、按季度或按年滚动到期日?

Capture.JPG

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

评论

  • Shaine格林伍德
    Shaine格林伍德 员工

    没有办法让Smartsheet自动为你创建循环任务，但只要你不使用依赖关系的日期列，公式是一种方法。你可以让你的公式简单到返回从之前的截止日期添加的天数的值…

    =[截止日期]1 + 30

    …或者使用更高级的条件，根据工作表中的其他值设置日期。我建议您查看我们的帮助中心了解有关f的详细信息功能，可在Smartsheet．

    我们还有一个公式语法如果您是在Smartsheet中制作公式的新手，请参阅本文。

    当您有时间时，请使用社区网站右侧快速链接下的产品增强请求表单，直接向我们的产品团队提交您对循环任务功能的反馈。ob欧宝娱乐app手机下载

    · 在Facebook上分享 在Twitter上分享
这次讨论已经结束了。

类别

@Julie Fortney<\/a> <\/p>

Happy to help!<\/p>

This is the one I was thinking about. It's been some time since I played around with it, so let me know what you think after you've tested it.<\/p>

\n \n https:\/\/trackingtime.co\/time-tracking-for-smartsheet\n <\/a>\n<\/div>

✅Remember! <\/strong>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":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":468,"urlcode":"resource-management","name":"Resource Management"},{"tagID":553,"urlcode":"timekeeping","name":"timekeeping"}]},{"discussionID":106749,"type":"question","name":"How to count how many interviews in the current week?","excerpt":"I am currently trying to track how many interviews are scheduled in the current week per fleet type? The formula I have is counting 7 days from today but I would like to be able to count for the current week. =COUNTIFS([Interview Date]:[Interview Date], @cell = TODAY(7), [Interview Date]:[Interview Date], @cell > TODAY(),…","categoryID":322,"dateInserted":"2023-06-22T01:59:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T03:13:30+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-22T03:41:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-22T05:23:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3374804596,"url":"https:\/\/community.smartsheet.com\/discussion\/106749\/how-to-count-how-many-interviews-in-the-current-week","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106749\/how-to-count-how-many-interviews-in-the-current-week","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106749,"commentID":381670,"name":"Re: How to count how many interviews in the current week?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381670#Comment_381670","dateInserted":"2023-06-22T03:13:30+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-22T05:23:48+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-22T03:41:21+00:00","dateAnswered":"2023-06-22T03:13:30+00:00","acceptedAnswers":[{"commentID":381670,"body":"

My apologies, I was counting interviews remaining in the current week. This will give you total interviews for the current week.<\/p>

=COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(7 - WEEKDAY(TODAY())), [Interview Date]:[Interview Date], @cell > TODAY() - WEEKDAY(TODAY()), Fleet:Fleet, \"A220\")<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106699,"type":"question","name":"Bridge Smartsheet Salesforce integration - redirect uri mismatch","excerpt":"Hello, I am trying to setup the Bridge Smartsheet Salesforce integration. I have followed the Smartsheet provided instructions at https:\/\/help.smartsheet.com\/articles\/2482029-salesforce-integration-overview-bridge to setup the Salesforce Connected App. I get the redirect uri mismatch error which says the redirect uri must…","categoryID":343,"dateInserted":"2023-06-21T15:05:04+00:00","dateUpdated":"2023-06-21T16:04:12+00:00","dateLastComment":"2023-06-22T04:28:35+00:00","insertUserID":134877,"insertUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":134877,"lastUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3374768619,"url":"https:\/\/community.smartsheet.com\/discussion\/106699\/bridge-smartsheet-salesforce-integration-redirect-uri-mismatch","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106699\/bridge-smartsheet-salesforce-integration-redirect-uri-mismatch","format":"Rich","tagIDs":[277,369],"lastPost":{"discussionID":106699,"commentID":381677,"name":"Re: Bridge Smartsheet Salesforce integration - redirect uri mismatch","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381677#Comment_381677","dateInserted":"2023-06-22T04:28:35+00:00","insertUserID":134877,"insertUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/B2DGWP3IILUP\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T04:28:43+00:00","dateAnswered":"2023-06-22T04:28:35+00:00","acceptedAnswers":[{"commentID":381677,"body":"

I solved the problem. A few key points:<\/p>

  1. The Callback URL in the instructions in Smartsheet Bridge - Salesforce Integration Overview<\/a> is wrong.<\/li>
  2. The correct Callback URL is:  https:\/\/system.converse.ai\/api\/settings\/oauth\/oauth2callback<\/li>
  3. I was able to analyze the error message to determine the correct redirect URI which is also the required Callback URL.<\/li><\/ol>

    Details of the solution<\/strong><\/p>

    How I found the solution<\/em><\/p>

    I determined the correct Callback URL by analyzing the Salesforce error that popped up when I clicked Connect on the Bridge.<\/p>

    What I clicked to generate the error<\/em><\/p>

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

    Resulting error message<\/em><\/p>

    I pulled the redirect URI from the message and added it to the Callback URL field in the Salesforce Connected App and that worked. See the second highlighted string.<\/p>

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

    Screenshot of correct settings for the Salesforce Connected App<\/em><\/p>

    Callback URL that works is:<\/p>

    https:\/\/system.converse.ai\/api\/settings\/oauth\/oauth2callback<\/p>

    \n
    \n \n \"User:<\/img><\/a>\n <\/div>\n<\/div>\n

    Neil<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":369,"urlcode":"bridge-by-smartsheet","name":"Bridge"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

    热门文章

    • 计时的启动/停止按钮?

      你好!我很想知道是否有人有停止/开始按钮的解决方案，以便在资源管理之外的智能表中记录团队成员的项目时间。这是一个没有访问任何高级应用程序的小团队。当一个新项目被设置时，它被添加到主项目列表表中，并手动添加到…

    • 如何计算本周面试的次数?

      我目前正在尝试跟踪每个机队类型在本周安排了多少次面试?我的公式是从今天开始计算7天，但我希望能够计算当前的一周。=COUNTIFS([面试日期]:[面试日期]，@cell =今天(7)，[面试日期]:[面试日期]，@cell >今天()，…

    • Bridge Smartsheet Salesforce集成-重定向uri不匹配

      你好，我正在尝试设置桥智能表Salesforce集成。我已经按照智能表提供的说明在https://help.smartsheet.com/articles/2482029-salesforce-integration-overview-bridge设置Salesforce连接的应用程序。我得到重定向uri不匹配错误，说重定向uri必须…