Tools used: Notion, Google Sheets, Google Apps Script, Slack

🧾 Overview

The Reliability Tracker system was designed to monitor, flag, and escalate practitioner-related incidents across operations. It included:

• A visual incident tracker in Notion
• A color-coded RSAT Tally dashboard in Google Sheets
• An escalation alert automation via Slack

The system helped improve visibility, accountability, and data-driven decision-making across the clinical support team.

🧩 Key Features

✅ 1. Notion-Based Incident Tracker

• Created a database per practitioner using relations and rollups
• Implemented visual escalation flags like:
  • 🦠 Strike 1
  • 💥 Strike 2
  • 🚨 Strike 3
  • ☠️ Recurring Issue
• Used Notion formulas like this to track repeat incidents:

text
CopyEdit
if(prop("Same Type Count") == 1, "🦠 Strike 1",
  if(prop("Same Type Count") == 2, "💥 Strike 2",
    if(prop("Same Type Count") == 3, "🚨 Strike 3",
      "☠️ Recurring Issue"
    )
  )
)

• Created logic to count related issue types per category using nested replace/format/length formulas

🔁 Zapier Integration with Google Sheets

• Connected Notion to Google Sheets using Zapier
• Every time a new incident was logged in Notion, Zapier automatically added it to a Google Sheet
• This kept the RSAT Tally dashboard in sync without manual copy-pasting