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.
-
Have a separate Sheet called say Stores - in there, have a Store Manager column. So each store has a Manager
-
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).
-
Choosing the Store will automatically fill in the Store Manager