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?
+1With 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)
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.