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

Eric Tinney
edited 12/09/19 in Archived 2017 Posts

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.





This discussion has been closed.