创建从初始日期计算的第二个日期
添加了具有已创建日期的行中的数据,我想在创建日期后30天自动执行预期关闭日期。然而,预期的关闭日期可能会移动,我希望能够改变的日子增加的日子,直到实际成为昨天。
我想用月和卖出周期的长度来进行预测。
我已经读到第一部分与=[Created Date] +30一起工作,但我无法使该公式给出除错误之外的任何结果,并且我已经尝试了基于帮助和社区中的评论的许多变体。
我觉得如果我能解决这个问题,我至少可以继续下一个问题。
有什么建议
评论
-
她名叫Stara ✭✭✭✭✭✭
你好,
您遗漏了公式应该查看的单元格。与@row函数,你不需要考虑引用哪个单元格号,只要你想引用同一行
试试这个。
(电子邮件保护)+ 30
奏效了吗?
你能更详细地描述一下你的过程吗?也许可以分享一下表格或一些截图?这将使它更容易为下一步提供帮助。(分享,(电子邮件保护))
祝你度过美好的一天!
最好的
她名叫Stara
工作流程顾问@完成咨询
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
Pepenav ✭
很抱歉回复晚了,我一直在商店里试着让不同的东西工作。对于这个问题,我创建了一个额外的列,叫做天数,并创建了一个触发器,但是当我有时间回顾事情时,我想回到你更简单的解决方案
-
她名叫Stara ✭✭✭✭✭✭
没烦恼!
什么时候合适,如果你需要任何帮助,请告诉我!
最好的
她名叫
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
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":[]}">