You're a support analyst building a row-level highlight rule for the queue dashboard. A ticket needs immediate escalation when all three of these are true at once:
- Status = Open (still in queue)
- Priority = High
- HoursOpen > 24 (past the 24-hour SLA)
Columns A–D contain TicketID, Status (Open/Closed), Priority (High/Medium/Low), and HoursOpen for 15 tickets.
Your task:
- In column E (EscalationFlag), write a single formula composing the three conditions with AND (or chained
* booleans inside an IF) that returns "Escalate" for tickets that need to escalate, "OK" otherwise.
- The formula must drag-fill from E2 → E16.
Graded cells: E2 (TKT-001 Open/High/36h → Escalate), E6 (TKT-005 Open/High/50h → Escalate), E12 (TKT-011 Closed/High/72h → OK, closed tickets don't escalate).
Open this problem on a desktop to attempt it.