Hey @lauragallagher! Could you please share further details and/or screenshots of the automation?
The issue is most probably found on an "update record" action block of your automation, which is setting the "Allocation" field blank -as per my understanding of your set up.

Happy to help out if you send that over.

Mike, Consultant @ Automatic Nation

Could you provide a screenshot of the project name field and the allocation field?  Knowing how your base is set up allows us to help you with troubleshooting

Thank you! Lmk if you need to see more.

Thanks! Lmk if you need to see more

Hmm, the screenshots don't provide enough detail to figure out what's happening I'm afraid

If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable

If you could also indicate which table and field the allocation column and project name column are that'd be great

here is the link: https://airtable.com/invite/l?inviteId=inv7cvWCDEeUirq5x&inviteToken=649ac2a0365ea77ca7b2e5aa393f09744b14a6a47ad9dabc8ba4bb1eac108909&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

 it is under 'monthly forecast allocations'. when the individual projects name changes, the 'projected allocations' and 'actual allocations' columns will delete. thanks!

Hmm, it looks like when the Project name changes, it's triggering the automation "3. Create Monthly Team Assignments" which in turn is creating new records for each month and team member for that project.  I think the records with the old Project name are then deleted by "6. Delete Inactive Monthly Forecast Allocations Records"

And so I suspect it's not that the column values are being deleted, but that the whole record is being deleted.  To test this, try opening a "Monthly Forecast Allocations" and then modifying its linked Project and see whether hte opened record gets deleted