Enumlist not showing all the names

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:

Screenshot 2023-06-01 at 3.20.04 PM.png  

In the Staff table here are the configs for the Name column.

Screenshot 2023-06-01 at 3.23.22 PM.png

Does anyone have any advice as to what I'm missing. 

Thanks in advance.

Solved Solved
0 1 68
1 ACCEPTED 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. 

View solution in original post

1 REPLY 1

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. 

Top Labels in this Space