Filtering data to create drop down menu

Copper Contributor


I'm trying to make a spreadsheet where when I select one task it will limit the option for the next column based on another set of data. So once I select a task it only shows employees that have a blank space in that task (image 2) on the drop down menu.


Any ideas would be great :)





0 Replies