Need help pulling info from one table to another

[SBeau]

Hello! I am currently pulling info from Jira into a table, and then pulling Sprint Start / End dates from Jira into another table. Because Jira doesn't expose that information directly, it is pulled into a GSheet, which I then pull into Airtable.

1. The Sprint Name is pulled from Jira directly into my main table, and there is an exact match for each in the Sprint Info table. 
2. I created a Link to Another Record field which sources from the Sprint Info table, and corresponding Start / End date Lookup fields based on that table. 
3. I created an Automation that looks for any records in my main table that have a non-empty value and updates the Sprint Info 'Link to' field with the value from the Sprint field (screenshot below).

When I generate a preview of the automation results, I can see that the Sprint Info linked field gets a value, but when I go back to my table, nothing is actually being updated. 

Any idea what I might be doing wrong, or a better way to accomplish this? 

[TheTimeSavingCo]

Automations only run on new datta that matches the conditions.  Could I confirm that new data's coming in and the automation isn't running?

---

If you're looking to deal with your old data, try clicking the field header of 'Sprint' and hitting CMD/CTRL + C, then click the field header of 'Sprint Info' and paste, this should link everything up the way you want

[SBeau]

OK, thanks! I have just confirmed that NEW data will be updated correctly. 

What concerns me about this approach is that this data will change. For example, when something moves from one sprint to another. Based on what I am hearing, it won't automatically update the new values for existing line items, so it sounds like I need to constantly copy the data from one place to the next. Is that accurate?

[TheTimeSavingCo · Accepted solution]

Depends on what kind of data change it is, really.  Does the change you're talking about force the record to meet the condition of 'Sprint' is not empty that you have in your screenshot?  i.e. are you first clearing out the 'Sprint' field before replacing it with another value?

If not, then you'll need to update your trigger condition to handle that.  Try giving it a condition of 'when record updated' and point it at the 'Sprint' field?  That way every time the 'Sprint' value is updated it'll trigger the automation to paste this value into 'Sprint Info'

How this is set up really depends on how your data is flowing and what your expected output is though, so let me know if the above doesn't work for you and why and I'll see what I can do to help!