Dependent Drop down list that populates from a data set

[acousticlife81]

I am having issues trying to get my dependent drop down boxes to work and populate from the data set. I am also trying to get the data to populate to a dashboard.
I need Date--> Location,Status ,Time ,Shift
Time -->Location--> Alpha--->A
Time --->Location --> Bravo --> B

Thanks

J

[TABLE="width: 1803"]
<tbody>[TR]
[TD]Report Number[/TD]
[TD]Date[/TD]
[TD]Month[/TD]
[TD]# of Incidents[/TD]
[TD]Day of Week[/TD]
[TD]Year[/TD]
[TD]Place[/TD]
[TD]Area/Location[/TD]
[TD]Status[/TD]
[TD]Description of Incident[/TD]
[TD]Count[/TD]
[TD]Rank[/TD]
[TD]Helper 1[/TD]
[TD]Helper 2[/TD]
[TD]Helper 3[/TD]
[TD]Helper 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]03/01/17[/TD]
[TD]March[/TD]
[TD]1[/TD]
[TD]Wednesday[/TD]
[TD]2017[/TD]
[TD]A[/TD]
[TD]ALPHA[/TD]
[TD]Access Denied[/TD]
[TD]Classified[/TD]
[TD]2[/TD]
[TD]First[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]03/01/17[/TD]
[TD]March[/TD]
[TD]1[/TD]
[TD]Wednesday[/TD]
[TD]2017[/TD]
[TD]B[/TD]
[TD]BRAVO[/TD]
[TD]Access Granted[/TD]
[TD]Non Classified[/TD]
[TD]2[/TD]
[TD]Second[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]03/01/17[/TD]
[TD]March[/TD]
[TD]1[/TD]
[TD]Wednesday[/TD]
[TD]2017[/TD]
[TD]C[/TD]
[TD]CHARLIE[/TD]
[TD]No Access[/TD]
[TD]Classified[/TD]
[TD]2[/TD]
[TD]Third[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

formula for helper: // this allows you to filter by date for right now [TABLE="width: 576"]
<tbody>[TR]
[TD]Helper 1[/TD]
[TD]Helper 2[/TD]
[TD]Helper 3[/TD]
[TD]Helper 4[/TD]
[/TR]
[TR]
[TD]=ROWS($B$5:C5)[/TD]
[TD]=IF(C5=$T$2,N5,"")[/TD]
[TD]=IFERROR(SMALL($O$5:$O$274,N5),"")[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

---

Drop Down Lists


[TABLE="width: 441"]
<tbody>[TR]
[TD]Date[/TD]
[TD]2/28/2017[/TD]
[/TR]
[TR]
[TD]Place[/TD]
[TD]ALPHA[/TD]
[/TR]
[TR]
[TD]Location[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Time [/TD]
[TD]12:00:00 AM[/TD]
[/TR]
[TR]
[TD]Rank[/TD]
[TD]First[/TD]
[/TR]
[TR]
[TD]

---

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dashboard[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Access Granted[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Access Denied[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]No Accesss[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Formulas
[TABLE="width: 882"]
<tbody>[TR]
[TD]Access Granted[/TD]
[TD]=COUNTIF($Y$5:$Y$270, "Access Granted")[/TD]
[/TR]
[TR]
[TD]Access Denied[/TD]
[TD]=COUNTIF($Y$5:$Y$271, "Access Denied")[/TD]
[/TR]
[TR]
[TD]No Accesss[/TD]
[TD]=COUNTIF($Y$7:$Y$272, "No Access")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Status[/TD]
[TD]=SUM(T9:T11)[/TD]
[/TR]
[TR]
[TD]Formula[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ALPHA[/TD]
[TD]=COUNTIF(X5:X270, "ALPHA")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BRAVO[/TD]
[TD]=COUNTIF($X$5:$X$272, "BRAVO")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CHARLIE[/TD]
[TD]=COUNTIF(X5:X274, "CHARLIE")[/TD]
[/TR]
</tbody>[/TABLE]

---

Drop down list data


[TABLE="width: 479"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Location[/TD]
[TD]Status[/TD]
[TD]Time [/TD]
[/TR]
[TR]
[TD="align: right"]1/1/2017[/TD]
[TD]ALPHA[/TD]
[TD]A[/TD]
[TD="align: right"]12:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2017[/TD]
[TD]BRAVO[/TD]
[TD]B[/TD]
[TD="align: right"]1:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/3/2017[/TD]
[TD]CHARLIE[/TD]
[TD]C[/TD]
[TD="align: right"]2:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/4/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/5/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]7:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/9/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/10/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/11/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/12/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11:00:00 AM[/TD]
[/TR]
[TR]
[TD="align: right"]1/13/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/14/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/15/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/16/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]3:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/17/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/18/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]5:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/19/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/20/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]7:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/21/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]8:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/22/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/23/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/24/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11:00:00 PM[/TD]
[/TR]
[TR]
[TD="align: right"]1/25/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/26/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/27/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/28/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/29/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/30/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]