Searching a column in another sheet
I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type.
An alternative would be a drop down list in sheet 2 that has all the contact names from sheet 1.
Help Article Resources
Check out the Formula Handbook template!