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!