Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 19, 2019 08:19 AM
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?
Dec 19, 2019 11:44 AM
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)
Jan 02, 2020 02:04 AM
That’s a great suggestion. I’ll try it out. Thank you!