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

Report Number

Date

Month

# of Incidents

Day of Week

Year

Place

Area/Location

Status

Description of Incident

Count

Rank

Helper 1

Helper 2

Helper 3

Helper 4

1

03/01/17

March

1

Wednesday

2017

A

ALPHA

Access Denied

Classified

2

First

1

1

2

03/01/17

March

1

Wednesday

2017

B

BRAVO

Access Granted

Non Classified

2

Second

2

1

3

03/01/17

March

1

Wednesday

2017

C

CHARLIE

No Access

Classified

2

Third

3

1

<tbody>
</tbody>

formula for helper: // this allows you to filter by date for right now

Helper 1	Helper 2	Helper 3	Helper 4
=ROWS($B$5:C5)	=IF(C5=$T$2,N5,"")	=IFERROR(SMALL($O$5:$O$274,N5),"")	1

<tbody>
</tbody>

---

Drop Down Lists

Date	2/28/2017
Place	ALPHA
Location	B
Time	12:00:00 AM
Rank	First
Dashboard
Access Granted	0
Access Denied	0
No Accesss	0

<tbody>
</tbody>

Formulas

Access Granted	=COUNTIF($Y$5:$Y$270, "Access Granted")
Access Denied	=COUNTIF($Y$5:$Y$271, "Access Denied")
No Accesss	=COUNTIF($Y$7:$Y$272, "No Access")
Total Status	=SUM(T9:T11)
Formula
ALPHA	=COUNTIF(X5:X270, "ALPHA")
BRAVO	=COUNTIF($X$5:$X$272, "BRAVO")
CHARLIE	=COUNTIF(X5:X274, "CHARLIE")

<tbody>
</tbody>

---

Drop down list data

Date	Location	Status	Time
1/1/2017	ALPHA	A	12:00:00 AM
1/2/2017	BRAVO	B	1:00:00 AM
1/3/2017	CHARLIE	C	2:00:00 AM
1/4/2017			3:00:00 AM
1/5/2017			4:00:00 AM
1/6/2017			5:00:00 AM
1/7/2017			6:00:00 AM
1/8/2017			7:00:00 AM
1/9/2017			8:00:00 AM
1/10/2017			9:00:00 AM
1/11/2017			10:00:00 AM
1/12/2017			11:00:00 AM
1/13/2017			12:00:00 PM
1/14/2017			1:00:00 PM
1/15/2017			2:00:00 PM
1/16/2017			3:00:00 PM
1/17/2017			4:00:00 PM
1/18/2017			5:00:00 PM
1/19/2017			6:00:00 PM
1/20/2017			7:00:00 PM
1/21/2017			8:00:00 PM
1/22/2017			9:00:00 PM
1/23/2017			10:00:00 PM
1/24/2017			11:00:00 PM
1/25/2017
1/26/2017
1/27/2017
1/28/2017
1/29/2017
1/30/2017
1/31/2017

<tbody>
</tbody>