Automations Across Tables with Formula Issue

Looking for help on an AirTable Automation please!

I have one table called Project Status, where I hand enter a Project Launch Date in one column and using a formula, calculate my Project Start Date in another column.

I have a second table called Project Schedule, where (using an Automation trigger), I pull the Project Launch Date from the Project Status Table, but also need to pull the calculated Project Start Date into a Calendar (non-formula) field. The Project Launch Date pulls succesfully, but the Project Start Date will not.

Any tips on how to make this happen? Thank you!

Could you please share more details about your automation that’s copying the dates between tables? If you’re able to share screenshots, that would be helpful.

On a side note, have you considered making a new “Project Schedule” view in your main table instead of duplicating data between tables?