Auto filling a cell based on the entry in another cell

dave.mcpherson56751
dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi,

We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name?

I dont want this on the form just on my sheet when the entry has been submitted.

Sorry i am really struggling with this and fear it is around Vlook up which i am also struggling with.

 

any help would be gratefully received

 

Dave Mac

Tags:
«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!