Create teams from scratch (using a spreadsheet)
If you want teams that aren't based on existing groupings like office, department, or job function, you can build them yourself using a spreadsheet. Here's how.
Step 1 — Set a join deadline Give participants a deadline to join the challenge, ideally a few days before it starts. Let them know that joining by this date is required to be assigned a team.
Step 2 — Create your teams In your challenge, create as many teams as you want. (Smaller teams generally drive stronger accountability.) Number them 1, 2, 3, etc. — the numbers are for your internal use; you can name the teams anything.
Step 3 — Download the challenge report In your Count.It Admin dashboard, go to Reports and download the challenge report. Open it in Excel, Google Sheets, or any spreadsheet tool.
Step 4 — Assign each member to a team Add a column next to each member's name. Enter a team number — either manually, or using a random formula. See: How to randomize numbers in Excel.
Step 5 — Share team assignments Send each person their team number, or post the full list somewhere everyone can see (Slack, email, intranet). Members can then join their assigned team in the app. That's it!