Use Google Sheets AI to Track and Analyze Safety Metrics

What This Does

Google Sheets' built-in AI can automatically calculate OSHA safety rates (TRIR, DART), generate trend charts, and surface insights from your incident data — without you needing to know complex formulas or spend hours building dashboards.

Before You Start

• You have a Google account (free)
• You have incident data available — even in a basic spreadsheet or as a list you can type in
• You know your total hours worked (or can estimate: number of employees × 2,000 hours/year)

Steps

1. Set up your incident data table

Open Google Sheets and create a table with these columns in Row 1: Date | Incident Type | OSHA Recordable? (Y/N) | Days Away? (Y/N) | Days Restricted? (Y/N) | Department | Shift

Enter your incident data in rows below. Even 6 months of data gives useful insights.

2. Let AI suggest your TRIR formula

Click on a blank cell where you want your TRIR calculation. In the formula bar, start typing and look for the Explore button (star icon) in the bottom-right corner of the screen. Click it. In the Explore panel, type "calculate TRIR using OSHA formula" and it will suggest the formula.

Alternatively, use this formula directly: =(COUNTIF(C2:C100,"Y")*200000)/[total hours worked]

Replace [total hours worked] with your actual hours figure or a cell reference. TRIR = (number of recordables × 200,000) ÷ total hours worked.

3. Build a monthly trend chart

Select your date column and recordable incident column. Go to Insert → Chart. Google Sheets will suggest chart types — select Line chart for trends. In the Chart Editor on the right, the AI-powered suggestions may recommend grouping by month automatically. If not, go to Setup and change the X-axis to group by month.

4. Use Explore for natural-language analysis

With your data selected, click the Explore button (bottom-right star icon). Type questions like:

• "Which department has the most incidents?"
• "Show incidents by shift"
• "What's the trend over the last 6 months?"

Explore generates instant charts and summaries you can insert directly into your spreadsheet.

5. Set up your DART rate calculation

In another cell, calculate your DART rate (Days Away, Restricted, or Transferred): =(COUNTIFS(D2:D100,"Y")+COUNTIFS(E2:E100,"Y"))*200000/[total hours worked]

This counts incidents with days away OR restricted work, multiplied by 200,000, divided by total hours.

Real Example

Scenario: You have a year of incident data and need to present monthly trends to leadership.

What you do: Set up the table with 40 rows of incident data. Click Explore and type "show recordable incidents by month as a bar chart." Google Sheets generates the chart instantly.

What you get: A bar chart showing monthly recordable incidents with a trendline — takes 30 seconds instead of manually building a chart from scratch.

Tips

• Keep your hours worked figure updated — a separate cell labeled "Total Hours Worked YTD" makes TRIR recalculation automatic
• Use data validation on the "OSHA Recordable" column (Y/N dropdown) to prevent typos that break your formulas
• The Explore feature works best with at least 20 rows of data — more data = better pattern recognition

Tool interfaces change — if a button has moved, look for similar AI/magic/smart options in the same menu area.