Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
Copy-Paste Rows WITH PREDECESSORS?
Hi,
When I copy-paste rows that are related by predecessors, these connections are lost.
Although I understand losing connections to rows that are not in the copy-paste panel, however it is a big time waste and error risk to have to re-create predecessors one by one.
Did I miss something? Is there an easy way around it?
Comments
-
Robin Sherwood Employee
Hi Charles,
Thanks for your feedback. You can actaully do this if you copy the whole row. So rather than selecting a range of cells which include the durations, start, end, and predcessor, click on the selection box just to the left of the row number and select the entire row or rows. Then right click and select copy, or just use Ctrl-C; when you paste it will maintain the dependencies. It will update all the references that point to rows within your copied tasks, and retain the original refrences to any tasks outside of your copied tasks.
Hope that helps,
Robin
-
Unfortunately it doesn't help.
The Paste option is not actually on once in the receiving sheet.
I used to try with the "Copy Row to Another Sheet..." but this way losing dependencies within the copied tasks.
Is there something in my set up I would have to change?
-
Travis Employee
Charles - Robins suggestion would work if you were copying/pasting rows within the same sheet but it sounds like you are referring to copying rows from one sheet to another. As you have seen, predecessors will not be copied which is partially because the row number of proceeding tasks are likely different across sheets (Task A is the proceeding task for Task B but Task A is on row 50 in one sheet and on row 122 in another sheet). If you want to copy predecessors from one sheet to another, first copy the rows to the new sheet then highlight only the processor values on the source sheet. Press CTRL + C to copy (CMD + C if you are on a Mac) then navigate to the predecessor column on the destination sheet and press CTRL + V to paste (CMD + V if you are on a Mac). This will copy all your selected predecessor values from one sheet to another.
-
My need is indeed accross different sheets.
Travis, your Ctrl+C/Ctrl+V proposal merely copies initial row numbers, i.e. "50" instead of needed "122", even though I would have transfered both tasks A and B, right?
So I still have my need uncovered I'm afraid.
(thank you for your input anyway)
-
Jeremy Michels ✭✭✭✭✭
Charles,
When you do the copy to the other sheet are you using the advanced features?
Is there a reason that you cant use linked cells to do the work you need?
-
认真对待。如果我从一个表行复制到的板块r, they should maintain their relative dependencies — the logic that made them what they are. Otherwise I just have to redo all the work. Am trying to parse the separate discussion about templates -- not immediately seeing how to apply this in a scenario where I'm trying to copy from a template or scenario project to a live project.
Every road leads me back to building this thing out line by line again from scratch. And there are a lot of lines.
Might need to step back and analyze. Perhaps there is an easy formula sitting there, just waiting for me to recognize and apply it. Apologies if I am missing it at this late hour with a deadline looming...
-
Thanks to everyone above
I agree with Project Manager time to step back and anlyze
How about this approach:
1) Start with a blank sheet
2) Create a colum called RTG for "Recurring Task Groups"
3) At the top of the sheet I enter the rows and depenencies of a recurring taks I will need later and mark them "NOT Active " in the RTG column
4) I make multiple copies of said sheet. (Call them "Blank sheets with Recurring Task Goups")
5) When I need to put together a sheet for a new prohect I start with one of rhe copies and rename it for the project and their RTG setting from "Not Active" to "Active"
This way when I need and RTG I just copy it in. Since it coms from the same sheet I get the internal dependencies.
6) Most of the time I will set the RTG filter so it does not show the "Not Active" RTG rows
随着时间的推移,我仍然会继续更新”“Blank sheets with Recurring Task Goups" by adding new RTGs
Why won't that work?
-
Our problem:
() We were creating projects, 1 per sheet. We immediately ran into problems getting the big picture using the critical path method because you can't represent dependencies accross sheets. The solution is to bring the projects together on to one big sheet and then use a t/f row called project tag which is uniquely named for each project. That solved. the "Too much information" problem. However - immediately we ran into what everyone else is describing here. What happened to our depnedencies.
What we did
() Standardized the column lists between all the sheets
() Select all the rows In the spreadsheet
() Use the copy row to another sheet function. Include attachments, etc.
() export the source sheet to excel.
() Insert a text field to the left of the predecessor column
() In the execel - adjust the columns to match the destination.
-This has to be done by hand if you have predecessors that look like this....14, 16FS +7d
() After the adjustments are done, paste that column into the additional column you added.
我发现你不能directly past into the predecessor column.
() Now cut/paste those cell contents into the predecessor column.
() repeat for the next sheet to be imported.
I hope this helps someone else.
-
Hi Vince,
Standard rows are not always enough and bits of specific experience is ferquently worth transfering, although it was not planned.
In these cases, the best I could find is
1) Copy linked rows to another sheet.
2) Predecessors conections are lost, we know it.
3) Move the new imported rows within the second sheet so as tro locate them on the SAME ROW NUMBERS they were in their original sheet.
4) Go back to original sheet and Copy predecessors
5) Paste predecessors in the second sheet.
6) This is good for links within the exported rows → You must clean/correct the predecessors connecting to rows outside the exported pool of rows of course.
_Not ideal but I hope it could be also useful to you.
-
If you are concerned about losing dependencies within the section of the SmartSheet you are copying (what I mean is, you those dependencies being within the group of rows you want to copy) - I have done it this way. Find a row number at the end of the destination sheet which is also blank within the source sheet from which you are copying (for example, 10 rows past the end of the longest sheet). Copy the original section (Location #1) you want to replicate to (#2) that same blank row number in the same sheet. The dependency numbers will change as appropriate! Then, copy that whole new section (#2) over to the new sheet - to the same row number (#3). The predecessor numbers will NOT copy over. Then go back to the original sheet and copy only the column of predecessor numbers from the original sheet (the rows in #2) to the new sheet in the same place (same row numbers). Voila! (Then just delete the rows in location #2 and do whatever other cleanup is needed.) :-)
-
Tylast ✭
The work around works, but the copy/move to another sheet should work better.
-
I'm not sure if this helps anyone but this is a work around.
I too make copes of my sheets weekly so that people can update. I don't have things directly linked to update because I like to be more in control of my master.
Rather than selecting cells from one sheet and doing "copy to another sheet". Go to File> save as new. Then you are making an exact copy of the whole document. It saves as exactly the same as the other document (with formulas, formatting, and predecessors). Then you can delete any unnecessary rows.
Categories
How exactly is your Data Shuttle set up? If it is set to replace everything in the sheet when it runs, it is deleting the cell being referenced by the widget and then putting new data in new cells.<\/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":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":108271,"type":"question","name":"Conditional formula - if a date is less than 30 days from today","excerpt":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula. =IF(AND([Event Date] > TODAY(), [Event Date] <= TODAY() + 30), \"Less than 30 days from today\", \"More than 30 days from today\") Help?","snippet":"I'm trying to create a conditional formula to flag if less than 30 days from today. I create a separate column to calculate but I am getting an error on the formula.…","categoryID":322,"dateInserted":"2023-07-28T18:21:58+00:00","dateUpdated":null,"dateLastComment":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":159884,"lastUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":18,"score":null,"hot":3381143059,"url":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108271\/conditional-formula-if-a-date-is-less-than-30-days-from-today","format":"Rich","lastPost":{"discussionID":108271,"commentID":387894,"name":"Re: Conditional formula - if a date is less than 30 days from today","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/387894#Comment_387894","dateInserted":"2023-07-28T19:22:21+00:00","insertUserID":159884,"insertUser":{"userID":159884,"name":"Connie Cochran","url":"https:\/\/community.smartsheet.com\/profile\/Connie%20Cochran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-28T19:21:59+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-28T19:21:56+00:00","dateAnswered":"2023-07-28T18:55:42+00:00","acceptedAnswers":[{"commentID":387890,"body":"
Try this:<\/p>
=IF(ISDATE([Event Date]@row), IF(AND([Event Date]@row > TODAY(), [Event Date]@row <= TODAY(30)), \"Less than 30 days from today\", \"More than 30 days from today\"), \"\")<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">