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!
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