Auto-fill based on Column value

Jason Pringle
edited 12/09/19 in Smartsheet Basics

I have a drop down box containing staff member names, when selected I want it displayed automatically in the "Assigned to" column our company name. I have searched help but so far no luck, can someone assist? cheers.