Best way to run a lookup when a row is added and not make it update dynamically?

Chad Miars
Chad Miars ✭✭
edited 06/22/22 in Formulas and Functions

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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!