How to move from spreadsheets to a database
The signs a spreadsheet has outgrown itself, and how to move without losing the flexibility that made it work.
Columns that match how work actually moves, cards that mean something, and WIP limits added at the right time.
Start with three or four columns that mirror how work already moves through your team — typically Backlog, In progress and Done — put every current task on a card with one owner, and only then think about limits and refinements. A board that describes reality is useful on day one; a board that describes an ideal process is abandoned by week two.
For a team of three to ten people that is the whole setup. The value comes from everyone seeing the same picture, not from the sophistication of the columns.
The most common starting layout is Backlog → In progress → Done. Teams that review each other’s work usually need a fourth column before Done. Resist adding more than that at the start: every extra column is another place for a card to sit while everyone assumes someone else is looking at it.
A work-in-progress limit caps how many cards a column can hold. It is the mechanism that turns a board into a system: when the limit is reached, the team finishes something before starting anything new.
Add limits after you have watched the board for a week or two, not on the first day. You cannot guess where work piles up — but you can see it, and the answer is usually different from what the team expected.
Ettex Board gives you columns, drag-and-drop cards, assignees, priorities, labels, subtasks and comments — and it sits next to your documents, chat and calendar, so a card can reference the actual document rather than a copy of it.
Three or four. Add a fifth only when you can name the specific problem it solves.
Kanban usually fits better: it has no sprints or fixed ceremonies, and it works with continuous, interrupt-driven work — which is what most small teams actually have.
Yes, as the first column, but keep it ordered and pruned. A backlog of two hundred cards is a place where ideas go to be forgotten.
A common rule of thumb is roughly one to two cards per person in the In progress column. Watch what happens and adjust — the number matters less than having one.
The signs a spreadsheet has outgrown itself, and how to move without losing the flexibility that made it work.
The five sections that matter, in the order visitors read them — and what to do before you pick a template.
Separate calendars per purpose, the right level of visibility, and how to keep it readable as the team grows.