Database of information from one sheet to another
I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution?
I've read a few forum posts that said that Smartsheet isn't a database, which I understand, but I'm wondering if the functionality I need might be possible in some other way.
I've been testing out this in Airtable as well, which seems a better option for this purpose, but I'm really hoping to use Smartsheet since my client has a Smartsheet account already.
Really appreciate your thoughts and advice.