创建从初始日期计算的第二个日期

Pepenav
Pepenav
编辑12/09/19 公式和函数

添加了具有已创建日期的行中的数据,我想在创建日期后30天自动执行预期关闭日期。然而,预期的关闭日期可能会移动,我希望能够改变的日子增加的日子,直到实际成为昨天。

我想用月和卖出周期的长度来进行预测。

我已经读到第一部分与=[Created Date] +30一起工作,但我无法使该公式给出除错误之外的任何结果,并且我已经尝试了基于帮助和社区中的评论的许多变体。

我觉得如果我能解决这个问题,我至少可以继续下一个问题。

有什么建议

标签:

评论

帮助文章参考资料欧宝体育app官方888

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
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":35,"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":106748,"type":"question","name":"I want to add a column that lists dates 6 months from other date column","excerpt":"Have tried a few different formulas and not working","categoryID":322,"dateInserted":"2023-06-22T00:40:47+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T03:01:34+00:00","insertUserID":162620,"insertUser":{"userID":162620,"name":"AnneMarie_1990_","title":"HR","url":"https:\/\/community.smartsheet.com\/profile\/AnneMarie_1990_","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T03:02:00+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":5,"countViews":24,"score":null,"hot":3374800341,"url":"https:\/\/community.smartsheet.com\/discussion\/106748\/i-want-to-add-a-column-that-lists-dates-6-months-from-other-date-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106748\/i-want-to-add-a-column-that-lists-dates-6-months-from-other-date-column","format":"Rich","lastPost":{"discussionID":106748,"commentID":381664,"name":"Re: I want to add a column that lists dates 6 months from other date column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381664#Comment_381664","dateInserted":"2023-06-22T03:01:34+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T10:06:39+00:00","dateAnswered":"2023-06-22T02:54:41+00:00","acceptedAnswers":[{"commentID":381661,"body":"

You can try putting this in. It is just the same formula with the IFERROR() removed. If that results in errors in those same cells, the date in that specific row may not be formatted correctly.<\/p>


<\/p>

=DATE(YEAR([First Date]@row), MONTH([First Date]@row) + 1, DAY([First Date]@row))<\/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":106687,"type":"question","name":"Adding one working day (no blanks)","excerpt":"Hi, I am trying to add a day onto a date generated from a previous date - However, it needs to be a working day and the cells with no previous date need to stay blank until the previous date is entered... i am currently using - =[Expected Final or QA Approval]@row + 1 - however the cells with no date in the previous cells…","categoryID":322,"dateInserted":"2023-06-21T13:22:59+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T07:39:15+00:00","insertUserID":161866,"insertUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T07:37:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161866,"lastUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T07:37:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3374774534,"url":"https:\/\/community.smartsheet.com\/discussion\/106687\/adding-one-working-day-no-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106687\/adding-one-working-day-no-blanks","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106687,"commentID":381679,"name":"Re: Adding one working day (no blanks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381679#Comment_381679","dateInserted":"2023-06-22T07:39:15+00:00","insertUserID":161866,"insertUser":{"userID":161866,"name":"Kirsteen Leckie","title":"Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/Kirsteen%20Leckie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T07:37:06+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T10:01:01+00:00","dateAnswered":"2023-06-21T14:06:52+00:00","acceptedAnswers":[{"commentID":381487,"body":"

Try this:<\/p>

=IFERROR(WORKDAY([Expected Final or QA Approval]@row, 1), \"\")<\/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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&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":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

公式和函数趋势