RASCI Matrix Template for Google Sheets
RASCI Matrix Template for Google Sheets
A five-role RASCI matrix in Google Sheets that extends RACI with a Supportive role, for tasks where several people contribute but only one person drives.
Free, ungated, opens in Google Sheets
- Five role markers (R, A, S, C, I) with dropdowns
- Task rows grouped by phase
- Team member columns
- Role count summary row per person
- Workload balance check with conditional formatting
- Shared editing with no version conflicts
How to Use This in Google Sheets
Make your own copy
Click Open in Google Sheets, then File > Make a copy. Your version saves to Drive with all dropdowns, formulas, and conditional formatting in place.
List tasks by phase and add your team
Enter tasks down the left, grouped under shaded phase header rows, and put each team member across the top. Phase grouping keeps a long matrix readable.
Assign the five roles
Pick a marker from each cell’s dropdown: R, A, S, C, or I. The new one is S for Supportive, used when someone actively helps with a task but does not own it. Keep one A per row.
Check the workload summary
The summary row totals each person’s R and S markers with COUNTIF. When one column climbs far above the others, conditional formatting flags it, so you can rebalance before someone is overloaded.
Share with the team
Use Share to give the team edit access. Because this is Google Sheets, several people can fill in the matrix together in a workshop without overwriting each other.
Who This Is For
Large teams with shared workloads
Groups where many tasks need more than one contributor and you need to see who is carrying too much.
Workshop facilitators
Leads running a live session where the whole team assigns roles together in real time.
Google Workspace teams
Teams already in Drive who want a shared, always-current matrix rather than emailed file versions.
Frequently Asked Questions
Yes. Make a copy to your own Drive at no cost. It uses only native Sheets dropdowns, COUNTIF formulas, and conditional formatting.
Use RASCI when multiple people contribute to single tasks and you need to capture supporting work, common on large teams. Use standard RACI when each task has one clear doer.
Yes. Share the sheet with edit access and several people can fill in roles simultaneously, which makes it well suited to live planning workshops.