Auto fill with data from another sheet

Eric Tinney

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.

 

 

Shaine Greenwood

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