Dependant dropdown lists

edited 12/09/19 in Smartsheet Basics

Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list of vendors and need to choose in vendor form their bank account. I write vendor name in column A , select "Bank" in column B, and i need a SWIFT code automaticaly  appear in column C according to information from banks list. This is simple task for Sharepoint. What about Smartsheet?