Filtering data to create drop down menu

Copper Contributor

Hey,

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 :)

 

 

20220901_180809.jpg

20220901_181249.jpg

0 Replies