Copy Start and End Dates (& Predecessors) from another sheet
Can this be done?
I have a project plan, and I want to pull over Start and End dates from another project plan. Predecessors, too. I tried typing a formula in the Start Date cell to link to the corresponding State Date in the other plan, but it doesn't seem possible.
Does anyone have any creative ideas on how to pull this off? Is it even possible?
Best Answer
-
Hi @Berto_DA
You will not be able to add formulas to those columns as they work with the project settings in your sheet.
How about creating an automation that copies your entire row from one sheet to the next, that way the entire row will copy over. This is a once off move though as it will not sync back to the original sheet.
IF you need this to be synced, you might have to create helper columns in the second project plan where you can add formulas and then manually update this sheet based on the information you have entered.
Hope this helpsMarcé Holzhauzen
Dare to try
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.
Answers
-
Hi @Berto_DA
You will not be able to add formulas to those columns as they work with the project settings in your sheet.
How about creating an automation that copies your entire row from one sheet to the next, that way the entire row will copy over. This is a once off move though as it will not sync back to the original sheet.
IF you need this to be synced, you might have to create helper columns in the second project plan where you can add formulas and then manually update this sheet based on the information you have entered.
Hope this helpsMarcé Holzhauzen
Dare to try
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome. -
Yes, the copying to rows would work. I tried it and it worked. Never did that before. Thank you for the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!