Automation Selection creates another selection

Is there a way to make an automation that takes a user-inputted selection and automatically selects another selection in a different column?

Example: I am trying to let the user input the “Store” column, and then the automation would auto populate the next “Manager” column with the corresponding manager for that store.

@Theo_Civitello - You typically enable this behaviour with a Related Row lookup setup.

  1. Have a separate Sheet called say Stores - in there, have a Store Manager column. So each store has a Manager

  2. Back in the first Sheet, create a Related Row column called Store (link it to Stores Sheet)and a Related Row Lookup column called Store Manager (pointing to Manager).

  3. Choosing the Store will automatically fill in the Store Manager