Automations Across Tables with Formula Issue

[S_Pacheco-Willi]

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!

[Justin_Barrett]

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?