Hello, I want to use the People column for it’s unique properties/notifications, etc.
I’m having trouble figuring out how to say use the People column 3 times on the same table but constrain each People column to only have People that meet certain criteria (position = “their position”) in each column.
This is for building an employee scheduling solution. I’d have a table with all of our locations, dates, shifts, and positions needed for each shift in each row i.e. all values are fixed/auto built but the scheduling team would use the table to click in each of the 3 People column drop downs to add the Person with that Position to the schedule in that column so I’m naming the columns Position 1, Position 2, Position 3 but can’t figure out how to only show the People with the column Position. I tried filtering but kind of auto adds every option and I’m really looking to keep this a drop down where someone selects the person just don’t them able to add a person with the wrong position into each column.