将日历应用程序上的开始日期提前

贾斯汀拉莫斯
贾斯汀拉莫斯 ✭
编辑06/14/22 在添加插件和集成

当我在日历应用程序上向后移动开始日期时，我没有任何问题。然而，当我试图将开始日期向上移动到结束日期之后时，我收到一条消息说，“结束日期必须大于或等于开始日期”。如果我启用了项目设置，结束日期不应该跟着开始日期吗?我将工作表设置为项目设置，建立了持续时间，并且无法编辑工作表或日历应用程序上的结束日期。在工作表中，我没有问题向上移动开始日期，只有当我尝试在日历应用程序中进行编辑时，它才会给我这个错误消息。

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

最佳答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理
    ✓回答

    嗨@Justin Ramos-Flynn

    日历应用程序的功能与源表不同;根据它的更新方式，您目前将无法将开始日期移动到结束日期之后以推出任务(正如您所发现的)。

    向前调整的方法是首先改变持续时间。这将推出结束日期，然后您可以将开始日期更改为新的较晚日期。一旦“开始日期”在正确的日期上，将“持续时间”调整回原始长度。

    否则，你可能想要直接转到源工作表来更改时间轴，这将更新日历应用程序中的更改。

    欢呼,

    吉纳维芙

    · 在Facebook上分享 在Twitter上分享

答案

  • 吉纳维芙P。
    吉纳维芙P。 员工管理
    ✓回答

    嗨@Justin Ramos-Flynn

    日历应用程序的功能与源表不同;根据它的更新方式，您目前将无法将开始日期移动到结束日期之后以推出任务(正如您所发现的)。

    向前调整的方法是首先改变持续时间。这将推出结束日期，然后您可以将开始日期更改为新的较晚日期。一旦“开始日期”在正确的日期上，将“持续时间”调整回原始长度。

    否则，你可能想要直接转到源工作表来更改时间轴，这将更新日历应用程序中的更改。

    欢呼,

    吉纳维芙

    · 在Facebook上分享 在Twitter上分享

类别

You would need to use a Move Row or Copy Row automation.<\/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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":106686,"type":"question","name":"Creating a form with multiple entries","excerpt":"Hi, So my issue is, I have a form that is designed to record incoming invoices. I need the form to firstly attach a number of invoices and create multiple entries. I've seen some ways to do this using another sheet and automation. The only problem with this is the form has to have pdf uploads of the invoices. So I'm not…","categoryID":321,"dateInserted":"2023-06-21T12:49:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162427,"lastUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3374866562,"url":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","format":"Rich","lastPost":{"discussionID":106686,"commentID":381901,"name":"Re: Creating a form with multiple entries","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381901#Comment_381901","dateInserted":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+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-23T09:30:18+00:00","dateAnswered":"2023-06-21T16:49:39+00:00","acceptedAnswers":[{"commentID":381537,"body":"

Hi @Zachwalters99<\/a> <\/p>

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

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.<\/p>

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

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/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":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106742,"type":"question","name":"Conditional Formatting","excerpt":"Hi, I need to apply conditional formatting based on another row in the sheet. Higher it should be highlighted in red, equal to or below highlighted in green. It would be easy to just use the target figures in the conditional formatting rules but I need to be able to change it frequently without changing all the formatting…","categoryID":321,"dateInserted":"2023-06-21T22:41:30+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T15:15:27+00:00","insertUserID":160222,"insertUser":{"userID":160222,"name":"WillH","url":"https:\/\/community.smartsheet.com\/profile\/WillH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T15:13:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":160222,"lastUser":{"userID":160222,"name":"WillH","url":"https:\/\/community.smartsheet.com\/profile\/WillH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T15:13:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3374836617,"url":"https:\/\/community.smartsheet.com\/discussion\/106742\/conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106742\/conditional-formatting","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":106742,"commentID":381752,"name":"Re: Conditional Formatting","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381752#Comment_381752","dateInserted":"2023-06-22T15:15:27+00:00","insertUserID":160222,"insertUser":{"userID":160222,"name":"WillH","url":"https:\/\/community.smartsheet.com\/profile\/WillH","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T15:13:35+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\/ARIIND3W8G3C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T15:15:35+00:00","dateAnswered":"2023-06-22T03:52:17+00:00","acceptedAnswers":[{"commentID":381675,"body":"

@isabonita<\/a> is on the right track. This is kind of an involved answer, but once you figure out the logic, it isn't that bad.<\/p>

You cannot reference specific cells in the conditional format in a manner that would make this easy. You cannot, for instance, say IF this specific cell is greater than that cell, apply this format. You can do it for the same row, but not always referencing the same cell. We get around this by inserting a \"helper\" column for each condition we want to check. The checkbox format works great. In the conditional format rule, you can simply say IF THIS cell is checked, apply the format to THAT cell. <\/p>

To set the checkbox to checked\/unchecked, we use this column formula: =IF(PDP@row > PDP#, 1, 0)<\/p>

But what is PDP#? This is another issue we have to work around. You cannot reference the first cell of a column in a column formula, you can only reference cells in the same row. To work around this, we add fields into the sheet summary. [PDP]# references the PDP field in the sheet summary. In order to make updating these values easier, we set the value of this field equal to the first cell in the PDP column using =PDP1<\/p>

After creating all of the helper columns, setting up the column formulas for each to determine which ones are checked, creating all of the necessary fields in the sheet summary, and setting those equal to the first cells in each of the respective columns within the sheet, we can set up the conditional formatting.<\/p>

Check out the image below to get an idea of how to setup the formats. Unfortunately, we have one more workaround to setup at this stage. Since the formatting will apply to every row in the sheet, it will apply to the first row as well and all of those cells will be green. To get around this, add the first format pictured below as the first one in your list. For the background color, you must select \"white\" in order to avoid the highlight. If you set it to \"no background\", you will get an error because Smartsheet does not see \"no background\" as a format.<\/p>

After everything is setup and running, you should be able to update the cells in your target row and things will work themselves out automatically.<\/p>


<\/p>


<\/p>

\n
\n \n \"Condition.PNG\"<\/img><\/a>\n <\/div>\n<\/div>\n

I hope this helps, and I really hope it makes sense.<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"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":5399,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 数据穿梭更新行工作流:防止重复更新

    嗨，我有一个数据穿梭更新工作流，它运行在一个时间表上更新行在目标智能表中，因为它们在存储在Box中的excel源文件中发生变化。我想看看是否有一种方法以某种方式配置数据穿梭工作流程，以便一旦一行被更新，它就不能再次更改。我试着这样做……

  • 创建包含多个条目的表单

    你好，我的问题是，我有一个用来记录发票的表格。我需要的形式，首先附加一些发票和创建多个条目。我已经看到了使用另一个表单和自动化的一些方法。唯一的问题是表单必须有pdf格式的发票上传。所以我不是…

  • 条件格式

    嗨，我需要基于工作表中的另一行应用条件格式。较高的应以红色突出显示，等于或低于绿色突出显示。在条件格式规则中使用目标数字是很容易的，但我需要能够经常更改它而不更改所有格式……