Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto fill with data from another sheet
So I'm not sure if this is possible. I have a sheet that has all of our employees on it. The list has four regional directors as the parent. Under them as the child are 5-10 field managers. What I'd like to have happen is if I made another sheet and set it up so if entered "Tech 1" it would auto fill who their "Field Manager" and Regional Manger" are without me having to look back to the master sheet.
Agian noty sure if this is even possible.
Comments
-
Hi Eric,
You might consider creating this with a nested IF statement or a lookup table. Note that the lookup table will need to be on the same sheet.
Details in these functions are in our Help Center: https://help.smartsheet.com/articles/775363-using-formulas
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives