Best way to run a lookup when a row is added and not make it update dynamically?
When a row is created in my sheet, I want to lookup an Employee's manager at the time the row was created. I have a sheet where I can lookup the manager based on the Employee. However, I don't want that to change on the row I am creating if the manager changes sometime in the future.
Is this best done in a workflow that I run when the row is created? That is where my head is, but wanted to confirm with the experts here.
Help Article Resources
Check out the Formula Handbook template!