Hi everyone,
Table A is meant to be just an overview of the project. The start dates, deadline given, and date returned will be entered manually as they change often. Here is a screenshot of the relevant part of Table A.
Table A
Now I’m creating Table B. In Table B I want to keep track of how long it took the team to finish each phase and each stage. Here is a screenshot of what I have so far:
You can see in Table B I will list each stage of a phase and I want to track the start and end dates for each stage. Ie it’s more detailed than Table A. I’m wondering if there is a way to capture the dates in Table A and put them in Table B. In Table A the “Phase” and “Stage” columns are Single or Multiple Select and will change as we progress through the phases. In Table B the “Phase” and “Stage” columns will not change because I want to capture the timeline for each stage in each phase.
So I want “Real Start Date” in Table B to capture the “Start Date” in Table A if it matches the same Phase and Stage. In other words, for row 1, TEPI13, when Table A is “Phase 1: Writing” and “Stage: Planning” the “Real Start Date” in Table B should show “8/12/2025”. But the phase, stages, and date in Table A will continue to change; whereas it needs to stay the same in Table B. So, I can’t just use “Lookup” in Table B for the start date in Table A, because it will continue to change. I also can’t use “If, then” based on the phase or stage, because as soon as the condition for “if” changes (for example, the stage) then it will no longer be true.
My guess is that I will have to do this manually, but I thought there’s no harm in asking! Thanks!
