Auto-fill contact details


I have a 'drop-down' column with lots of different suppliers (Company Names) in the drop-down list.

My next column is 'supplier contact', next column ' supplier contact number'.

Is it possible to get the 2 adjacent columns to auto-fill with the correct contact and contact number according to the company name selected ?

I understand I'll need to input the details the first time, but want to automate it.

Thank you for any help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!