Forum Discussion
barbdd12
Jan 29, 2025Copper Contributor
Help with Dynamic Calendar
I have two teams in which they both have various tasks/deployments and would love to bring both the lists to one calendar view. I found this template which includes the assignments, month view and we...
insightsgeek
Jan 30, 2025Brass Contributor
Hi barbdd12 ,
It sounds like you want to combine deployment tasks from two teams into a single calendar view while ensuring that:
- Both teams can update their own sheets (Mobile & POS).
- The data is structured in a uniform way before populating the "Assignments" tab.
- Due dates automatically populate into the Assignments tab so they flow into the monthly/weekly calendar.
My approach would be to go with Power Query to merge the data.
Since you're already using Power Query, the key issue is ensuring that merged data updates the Assignments tab, not just a new sheet. Here's how to do it:
- Load the Mobile & POS Sheets into Power Query
- Merge Both Queries into One
- Load the Merged Data into the Assignments Tab
- Click Close & Load To...
- Choose "Existing Worksheet" and select the Assignments tab.
Ensure Due Dates Populate Correctly
- If due dates aren’t showing, check that the column headers match exactly in Mobile, POS, and Assignments.
You can also automate it as much as it can be.
- Power Query Refresh: Go to Query Properties and set it to auto-refresh when opening the file.
- Data Validation: Ensure both teams use consistent naming for columns, especially the date field.