Automations Across Tables with Formula Issue

Topic Labels: Automations
618 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

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?