Spreadsheet: 726579d1617303016-conditional-formatting-formula-question-example-workbook
Sheet: IncidentDetails

Incident Number | Date Submitted | Consumer | Office | Reported By Name | Reported By Title | Date of Incident | Time of Incident | Incident Type | Incident Location | Critical IR? | Business Days b/n Incident & Submission | Compliant? | Program Coordinator | DDSD Case Manager | Suspected Abuse, Neglect, or Exploitation Notification | Adult Protective Services | Child Welfare Services | Office of Client Advocacy | Abuse Hotline | Threat of Suicide | Attempt of Suicide | Death | Unplanned Hospital Admission | Psychiatric Facility | Medication Event Resulting in Need for Emergency Medical Treatment | Law Enforcement Involvement | Criminal | Behavioral | Other Law Enforcement Involvement | Other Law Enforcement | Loss of Property More Than $500 | Fire | Natural Disaster | Behavioral Destruction | Theft | Other | Other Property Loss | Missing Person | Person Located? | Law Enforcement Notified | Risk Factors | Other Risk Factors | Use of Restrictive or Intrusive Procedure | PRN Medication for Behavioral Control | PRN Medication Name | PRN Medication Dose | PRN Medication Time | PRN Medication Protocol in Place? | PRN Medication Protocol Followed? | Physical Hold | Amount of Time in Hold | Authorized in PIP? | Injury | Client Injury | Staff Injury | Other Injury | Other Restrictive Procedure | Procedure Description | Injury | Unplanned Health-Related Event | Treatment Not Required | Emergency Room Visit | Transport By Ambulance | Treatment, Consultation or Both by Physician | Treatment by Other than Physician | Physical Agression Toward | Self, Self Injurious | Staff | Others | Fire Setting | Deliberate Harm to an Animal | Loss of Property Less Than $500 | Fire | Natural Disaster | Behavioral Destruction | Theft | Other Property Loss | Other Property Loss Description | Vehicle Accident | Suspension, Removal or Termination of Person's Program (including employment) | Medication Event | Dose at Wrong Time | Wrong Medicine | Documentation Incorrect | No Medical Treatment Required | Missed Dose | Wrong Route | Incorrect Label or Instruction | Wrong Dose | Refused Medication | Other Medication Event | Other Medication Event Description | Incident Details | Follow Up Action Taken by PCS | Program Coordinator Signature | Program Coordinator Signed Date | Management Review Signature | Management Review Signed Date | DDSD Case Manager Signature | DDSD Case Manager [NAME]
0225513 | 12/02/2019 | [NAME] | Cleveland | [NAME] | DSP | 12/01/2019 | 08:00 AM | Discovered | Home |  |  |  | Sid | [NAME] | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No |  | No | No |  |  |  | No | No |  |  |  | No | No | No |  | No | No | No | No | No | No |  | No | Yes | No | Yes | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | Yes | No | No | No | No | No | No | No | No | No | Yes | out of med....ER gave her med | asdfs | asdfdasf |  | 12/02/2019 |  |  |  | 12/04/2019
0225514 | 12/02/2019 | [NAME] | Dallas | [NAME] | DSP | 12/01/2019 | 03:58 PM | Discovered | Home |  |  |  | Manfred | Sheriff Woody | No | No | No | No | No | No | No | No | No | No | No | Yes | No | No | Yes | missing person | No | No | No | No | No | No |  | No | No |  |  |  | No | No |  |  |  | No | No | No |  | No | No | No | No | No | No |  | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No | No | No | No | No | No | No | No |  | asdsdf | asdfafds |  | 12/02/2019 |  |  |  | 12/06/2019
0228133 | 01/24/2020 | [NAME] | Chicago | [NAME] | AD | 12/01/2019 | 04:00 PM | Discovered | Home |  |  |  | Diego | Little Bo-Peep | Yes | No | No | Yes | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No |  | No | No |  |  |  | No | No |  |  |  | No | No | No |  | No | No | No | No | No | No |  | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No | No | No | No | No | No | No | No |  | asdfasdf | asdfsdf |  | 01/24/2020 |  |  |  | 01/28/2020
0225530 | 12/06/2019 | Goofy | Portland | [NAME] | Program Manager | 12/01/2019 | 05:30 PM | Observed | Other |  |  |  | Scrat | Slinky Dog | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No |  | No | No |  |  |  | No | No |  |  |  | No | No | No |  | No | No | No | No | No | No |  | No | Yes | No | Yes | No | No | No | No | No | No | No | No | No | No | No | No | No | No | No |  | No | No | No | No | No | No | No | No | No | No | No | No | No |  | asfsdfa | asdfdsf |  | 12/06/2019 |  |  |  | 12/06/2019