I have created an Automation that auto-assigns a technician based on names in another cell within the same sheet and it is not changing my cell values:
The Trigger is set for when a row is added (rows are typically added in bulk as a copy paste from an Excel File)
The "Audit Assigned to" Field is a single-select dropdown