Back to Blog
work

Internal tools for small teams: the one you keep meaning to build

Every ops team has a spreadsheet that should be a real tool. Here are the three tests we use before building one.

ColumnlineSeptember 22, 20262 min read

Every operations team I meet has one. A spreadsheet that three people update, a folder of forms, a process that lives in one person's head. Everyone agrees it should be a real tool. Nobody has two weeks to build one.

warehouse
warehouse image

So it stays a spreadsheet. The cost is invisible, which is why it survives. Nobody logs the hour lost to a wrong version, or the customer who waited because the person who knew the answer was away.

Here is the test we use before building anything. Can you name the job the tool does in one sentence, without using the word manage? If you can, it is small enough to build. If you cannot, it is two jobs wearing one coat, and it will be late.

The second test is the handoff. Most internal tools are not really about data. They are about the moment work passes from one person to another. A quote goes for approval. A property changes status. A draft needs a second pair of eyes. Get the handoff right and the tool mostly writes itself, because the screens follow the steps.

Photo 2

The third test is what happens when someone gets it wrong. Good internal tools make the wrong thing hard and the right thing obvious. They do not rely on training, and they never rely on remembering.

None of this needs a platform team. It needs someone to write the sentence, name the handoff, and decide what happens on a bad day. The building is the easy part now. Basecamp's Shape Up makes the same point about fixing the appetite before the scope.

development
development image

If you have one of these in your business, start with the sentence. If you cannot get it to one line, that is the finding, and it is usually worth more than the tool. If you cannot decide which one to start with, that is the same question as who your first AI workflow should be for.

Tags
internal tools for small teams