Thanks for pointing me to the right direction Scott! I have figured it out. Cheers!

Hey @ScottWorld,! How do I move a formula field's result into a linked record field using Automation? I couldn't figure out how.For instance below, I want to move the result of "Week Number", which is a formula field, into a new field called "Linked_...

We need this!! Agree, that this is a basic feature that needs to be in Airtable Interfaces so we can do proper dashboard reporting.