Need help with creating a record of dates from one table to another

[Mae_Infante]

Hi guys!

I have a table called “Production Stage” (reference below), with lots of dates which can be quite tricky to look at. So I created another table “Project Breakdown” with a simpler view and only have Start & End date.

I need to fill up the dates in Project Breakdown by linking it from the Production Stage, but by linking it, it creates a record for the entire line (vertically) instead of just in its specific category.

For example, a date was created for “Drug Bust Pre-Production End” in Production Stage, and I want it to appear in Project Breakdown but only under “Drug Bust - Pre-Prod End”. I hope this made sense.

Is there any automation that can help with this? Would appreciate the suggestions in advance!

Production Stage

Project Breakdown Table

[TheTimeSavingCo]

Hi Mae, I’ve set something up here that I think does what you’re looking for

The idea is to make an automation that will create one record per project phase (Development, pre-production, etc), and then use the SWITCH() function to set up which phase’s start and end date to display

Let me know if you have any questions