For organizers › Google Sheets
Google Sheets
Copy every daily status to a Google Sheet your organization owns.
Link a Google Sheet and CrewBook copies daily statuses into it, usually within a minute. The sheet stays yours: you can share it, filter it and keep it after you stop using CrewBook.
Two kinds of sheet
| Sheet | What’s in it |
|---|---|
| Project sheet | One project’s daily statuses, one row per task, with an Organization column. |
| Organizer sheet | Every employee’s daily status across all projects, with a monthly Team Overview and weekly and monthly summaries. Only your own employees; partners’ people are left out. |
Link a sheet
- Create a sheet in Google Sheets.
- Choose Share and add the email address CrewBook shows you (Copy email) as Editor.
- Copy the sheet link from the address bar.
- In CrewBook open Email & Sheets, pick the project or the organizer sheet, paste the link and choose Link sheet.
Last synced shows when CrewBook last wrote to it. Open in Google Sheets opens it.
Summaries
On a sheet’s settings you can turn on a Weekly Summary and a Monthly Summary, and on the organizer sheet a Team Overview: each month, people by working day with ✓ sent, ✗ missed and Lv for leave. Days missed counts closed working days with no status and no approved leave.
Good to know
- The sheet is a copy. Edits in the sheet don’t come back to CrewBook.
- Changing a project’s status fields rebuilds its sheet’s columns.
- Unlink stops new statuses being written. What’s already in the sheet stays there.