Referencing list

So we are using smart sheets for Behavior Based Safety observations

I have a sheet that has a total by employee I want the employees to enter their ID number instead of their Name and it auto populate their name on the sheets.

SO

Employee will fill out a form and submit their observation. Instead of entering their name they will use their employee ID and it will auto add their name to the sheet


I was thinking it would like this

=INDEX({REFERENCE ID FROM MASTER SHEET}, MATCH([column on bbs sheet with employee id]@row , {Reference from mastersheet for name of employee}, 0))

Then the cell that i put this formula in would automatically populate with thier name?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!