I have a project management app. I have a staff table, which lists all staff and I have have a tasks table, where specific tasks are linked to staff. Staff can be linked to a task as either the LEAD (1 name) or SUPPORT (multiple).
The problem I'm having is with the Enumlist in the tasks table for SUPPORT. When I go to select SUPPORT in the App, not all of the names for staff appear, and this changes for different tasks. Some tasks there are a few options in the dropdown, and in others there are only 2. So its plarty working. I have been able to edit a task and assign 2 staff members as SUPPORT.
In my Tasks table here are the configs for Support column:
In the Staff table here are the configs for the Name column.
Does anyone have any advice as to what I'm missing.
Thanks in advance.
Solved! Go to Solution.
Its all good. I went back to the original Google Sheet, and set data validation to selected range for that column and that fixed the problem.
Its all good. I went back to the original Google Sheet, and set data validation to selected range for that column and that fixed the problem.
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |