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.
Best Answer
-
I would create a separate sheet and convert this original into a "lookup" sheet. The newly created sheet would be the "working" sheet.
Run the lookup on this first sheet, then have a copy row automation set up to copy the row when the manager cell is filled in.
Have it copy the row over to the "working" sheet and run the rest of everything else from there.
Answers
-
I would create a separate sheet and convert this original into a "lookup" sheet. The newly created sheet would be the "working" sheet.
Run the lookup on this first sheet, then have a copy row automation set up to copy the row when the manager cell is filled in.
Have it copy the row over to the "working" sheet and run the rest of everything else from there.
-
Thanks for the help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!