Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Drawing some multiple select options from another column

798 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelle_Kirsch
5 - Automation Enthusiast
5 - Automation Enthusiast

In my table, I have column 1 and column 2 with multiple select options for names. Column 1 has project leads (which include only senior managers) and Column 2 (which include both junior staff and senior managers).

I manually added names of junior staff in Column 2 but I was to customise it so that the names of senior managers are drawn from the options in Column 1.

Can anyone help?

2 Replies 2
Jonathan_Letts1
6 - Interface Innovator
6 - Interface Innovator

With this many people involved have you considered making it a linked record and linking it to a people table?

That would give you the ability to store additional information. And in a linked field you can limit selection to a view (managers vs staff)

That’s a great suggestion. I’ll try it out. Thank you!