acousticlife81
New Member
- Joined
- Mar 29, 2017
- Messages
- 12
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
<tbody>
</tbody>
formula for helper: // this allows you to filter by date for right now
<tbody>
</tbody>
Drop Down Lists
<tbody>
</tbody>
Formulas
<tbody>
</tbody>
Drop down list data
<tbody>
</tbody>
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>