Drawing some multiple select options from another column

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?

1 Like

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)

1 Like

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

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.