Forum Discussion
Conditional data validation drop downs
I have a table with everyone's availability. Column A is names, Column B is Monday morning, Column C is Monday afternoon and so on. In another cell, I want a drop down list of names if they're availa...
Hi
Assuming your data is on Sheet1 with Names in A2:A5:
Create a new Sheet2 (you can hide later):
#1 On Sheet2 in A2 then copy right as necessary:
=FILTER( Sheet1!$A2:$A5, Sheet1!B2:B5 = "available", "" )#2 Switch to Sheet1 > In Data Validation on B7 and copy right as necessary:
=Sheet2!A$2#(Don't forget the # sign at the end)
Sample avail. at: https://1drv.ms/x/c/1cd824d35610aacb/IQBN8UpV0kxfQJ5AFzs1WF3hARCxMpkCqNADQBR6vtlVPMY?e=uaMDfX