Auto filling a cell based on the entry in another cell

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


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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!