Like many of you I have data (lets call them projects). They come in as an idea on a form, users supply some data, it is verified, and achieves a stage to move on, When it moves on it has accrued much data that does not need to move with it so only SOME columns need to be created in another sheet with the same data.
Now I know we can do some index/match, but for large complex, many user environments that get resorted regularly, copy/move is a better option.
2023 saw some increases in row counts/cell counts etc but this would seem unnecessary if as things moved from stage to stage to stage, and thus team to team to team, they did not pickup hundreds of extra columns along the way.
-----
Any solutions newer than "Helper Sheets", or accruing large volumes of unnecessary columns; These have been our only options for some years now.
This has to do with how a milestone is represented (ie. a 0 day duration). If you hard type milestone without a predecessor or successor, it will show up as the beginning of that day instead of the end of the day. If you have a milestone that is following a standard finish to start logic, it will show up at the end of the previous activity. <\/p>
So, Task B4 in the backwards version is actually saying that the completion happened in the 00:00 hr of that day. if you put any activity in that has a duration and uses the start to finish relationship, that activity will naturally finish at the end of the previous day. So, to get your example above to work, the finishing task would need to be 1 day long so it takes up the full work day. I found it easier to visualize if you zoom all the way in on the gantt chart so you can see the diamond symbol of the milestone at the beginning and end of the days when used in different set ups.<\/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":108291,"type":"question","name":"Conditional formatting in Gantt not working with dependencies","excerpt":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…","snippet":"For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable…","categoryID":321,"dateInserted":"2023-07-29T22:50:55+00:00","dateUpdated":null,"dateLastComment":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164323,"lastUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3381404343,"url":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108291\/conditional-formatting-in-gantt-not-working-with-dependencies","format":"Rich","tagIDs":[219,319,437,439],"lastPost":{"discussionID":108291,"commentID":387971,"name":"Re: Conditional formatting in Gantt not working with dependencies","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387971#Comment_387971","dateInserted":"2023-07-30T15:38:08+00:00","insertUserID":164323,"insertUser":{"userID":164323,"name":"smbailey","title":"Senior Business Systems Analyst","url":"https:\/\/community.smartsheet.com\/profile\/smbailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-30T15:36:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/4N6Y1NCLVR43\/2023-07-29-15-46-58-281-29-moving-plan-smartsheet-com.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2023-07-29 15_46_58-(1) Moving plan - Smartsheet.com.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-30T15:39:24+00:00","dateAnswered":"2023-07-30T09:21:36+00:00","acceptedAnswers":[{"commentID":387967,"body":"
Genevieve P. Employee Admin
