Overview
This template works for non-profits and community organizations with up to a few hundred active volunteers. Captures interests, availability, skills, and accumulated hours.
Column layout
Copy this column order into a blank Google Sheet, or let SheetLink Forms create the headers for you on first submission.
| Column | Notes |
|---|---|
| Volunteer ID | Unique ID |
| Signed up | Date |
| Name | |
| Phone | Optional |
| Interests | Multi-select: Events / Admin / Outreach / Tutoring / Logistics |
| Availability | Weekdays / Weekends / Evenings / Flexible |
| Skills | Freeform - languages, specialized skills |
| Background check | Not Needed / Pending / Cleared |
| Waiver signed? | Boolean |
| Hours YTD | Manually maintained |
| Coordinator | Assigned staff contact |
| Status | New / Onboarded / Active / Inactive |
| Notes | Freeform |
Useful formulas
Paste these into a top-of-sheet summary row or a separate dashboard tab.
Active volunteer count
=COUNTIF(M:M,"Active")Total hours YTD
=SUM(K2:K)New signups this month
=COUNTIFS(B:B,">="&EOMONTH(TODAY(),-1)+1,B:B,"<"&EOMONTH(TODAY(),0)+1)Conditional formatting
- Background check: red if Pending, green if Cleared.
- Waiver column: red if FALSE - flags missing paperwork.
- Status: green for Active, gray for Inactive.
Pivot table guidance
Pivot with Interests as rows, counts as values. Shows where volunteer capacity is concentrated - useful for matching against project needs.