How to overlay Team Vacation Planner into my Project Plan?

Hi,
I have 2 separate spreadsheets, a Project Plan and a Team Vacation Planner. Is there anyway I can incorporate the Team Vacation Planner with all the team members holidays into the Project Plan without having to retype all the holiday dates into the project plan?
Plus, anytime the Team vacation planner changed, this would be updated and referenced in the Project Plan? it would be great esp in gannt chart view to see the project milestones and timeline against the team availabilities.
Thanks
Answers
-
Hi @S Lim
The way I would personally do this is to create a Row Report using the two sheets as the source for the Report. Then you can Sort the Report by Date, so the Team Vacation dates are spread among your Project Plan.
Reports are automatically updated as rows are updated/added to the underlying source sheets. Here's more information: Build a row report / Working with source sheets in reports / SmartStart: Reporting
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
This is an old post so hopefully you see this. I tried this but when I started filtering between the two sheets my data between the sheets would be hidden because the columns aren't 1 for 1. Is there an alternative option to achieve what @S Lim is trying to do?
-
Hi @Vivre Belle
You could copy the row data from one sheet into the other when it's added with a workflow, but then your rows won't be synced between sheet, and the column names/types would need to be the same to be filled in (like with a Report).
Another option would be to use formulas to bring data from one sheet into the other (see:
)Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives