用报告更新开始日期
大家好，一个相对新手的快速问题:
我正在建立一个项目表，并希望能够发布报告更新到我们的项目上的外部承包商。我正在努力使用智能表的一个功能。我想让我的工程公司提供一个开始日期的任务与依赖关系，而不必创建一个延迟(这将超出了大多数用户的舒适区)。
这是我的目标:
步骤1:创建基本设计(工期10天)
第二步:完成现场调查和参观(为期5天)
步骤3:创建许可证准备图纸(工期10天)
工程公司需要能够告诉我他们什么时候开始现场调查，这可能是在开始基础设计后至少10天，但他们实际上可以在基础设计完成后的任何时间开始(即不一定是10天)。现在我能填的报告只有%完成了。我不能让他们从“创建基础设计”中输入超过10天的开始日期。这对我来说没有意义，你不能标记什么时候你会把资源投入到一个项目中。欧宝体育app官方888有什么解决办法吗?
克里斯
评论
-
蒂姆·米克斯 ✭✭✭✭✭✭克里斯,
如果我理解你的解释，你想要的灵活性，能够有第2步的开始日期，而不是立即在第1步结束后。
在SS中，当我将步骤2的开始日期移动到第二天以上时，它将从步骤1和步骤2中删除先前依赖项。在MS Project中，它会警告您已将步骤2的开始日期移到了步骤1之后，并询问您是否要保留该链接。换句话说，您希望SS允许手动调度而不是自动调整日期。
为了代替SS中的这个功能，即使你说你不想处理延迟，我唯一的建议是保持步骤1和步骤2之间的依赖关系，在两者之间创建一个名为“延迟”的任务，或者你的团队可以理解的其他东西。它将用步骤1和步骤2之间的天数填充，并允许您保留依赖项。
我不确定这个解决方案是否有用，但这是我能想到的唯一办法。
我很乐意听到其他的想法。
蒂姆
类别
Ok I think I got it. It's due to the times you need to combine the dates and times to get it to consider both as a whole and not individually. So you will need a helper column for your start date\/time and end date time. I titled mine as Start Date Time Helper and End Date Time Helper. If you title them the same you should be able to copy and paste formulas.<\/p>
Start Date Time Helper<\/p>
=IFERROR(VALUE(YEAR(DATEONLY([Start Date]@row)) + \"//m.santa-greenland.com/community/discussion/1941/\" + IF(MONTH(DATEONLY([Start Date]@row)) < 10, \"0\") + MONTH(DATEONLY([Start Date]@row)) + IF(DAY(DATEONLY([Start Date]@row)) < 10, \"0\") + DAY(DATEONLY([Start Date]@row)) + IF([Start Time]@row < 1000, \"0\") + [Start Time]@row), \"//m.santa-greenland.com/community/discussion/1941/\")<\/p>
End Date Time Helper <\/p>
=IFERROR(VALUE(YEAR(DATEONLY([End Date]@row)) + \"//m.santa-greenland.com/community/discussion/1941/\" + IF(MONTH(DATEONLY([End Date]@row)) < 10, \"0\") + MONTH(DATEONLY([End Date]@row)) + IF(DAY(DATEONLY([End Date]@row)) < 10, \"0\") + DAY(DATEONLY([End Date]@row)) + IF([End Time]@row < 1000, \"0\") + [End Time]@row), \"//m.santa-greenland.com/community/discussion/1941/\")<\/p>
Formula to get your Yes\/No's<\/p>
=IF(COUNTIFS(SAP:SAP, SAP@row, [End Date Time Helper]:[End Date Time Helper], @cell >= [Start Date Time Helper]@row, [Start Date Time Helper]:[Start Date Time Helper], @cell <= [End Date Time Helper]@row) > 1, \"No\", \"Yes\")<\/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":106584,"type":"question","name":"Index Match, how to recognize multiple values?","excerpt":"Hello, I have an issue with my index match formula. I want to locate the facility for a serial number. This works perfectly when there is only one value inside. However to reduce the amount of columns and options on the corresponding form, I changed it to one column that has multiple values. The formula is having…","categoryID":322,"dateInserted":"2023-06-18T21:21:35+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162488,"lastUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3374265958,"url":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106584\/index-match-how-to-recognize-multiple-values","format":"Rich","lastPost":{"discussionID":106584,"commentID":381112,"name":"Re: Index Match, how to recognize multiple values?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381112#Comment_381112","dateInserted":"2023-06-19T02:24:23+00:00","insertUserID":162488,"insertUser":{"userID":162488,"name":"Marcus Halvorson","title":"Marcus Halvorson","url":"https:\/\/community.smartsheet.com\/profile\/Marcus%20Halvorson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T02:48:51+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\/NDLYM9DFIQOI\/f1-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"f1.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T02:22:26+00:00","dateAnswered":"2023-06-19T02:12:19+00:00","acceptedAnswers":[{"commentID":381111,"body":"
