The Spreadsheet Skill Monday.com Still Can’t Replace

Watch a project meeting run on Monday.com and the appeal is immediate. A red block needs attention. A green block is done. Owners, dates and dependencies sit in a board that can become a timeline, calendar, Gantt chart or Kanban view. The room does not need a tutorial before it can read the weather.

Now sit beside the operations analyst after the meeting. She is not asking whether the board is pretty. She wants to total approved spend from another department’s sheet, match a project code to a rate table, exclude canceled work and return a blank instead of an error. Her work begins where the color blocks stop.

That is the useful way to understand Monday.com versus Smartsheet. Both products manage collaborative work. Both have automations, dashboards, multiple views and formulas. The split is not a box-checking contest. It is a difference in product grammar. Monday.com starts with the board and adds calculation. Smartsheet starts with the grid and preserves much of the language spreadsheet users already know.

The stickiest feature is often the formula nobody remembered to put in the migration plan.

The board and the formula bar

Monday.com’s visual instinct is explicit. Its status column can be customized with more than 40 label colors, and its documentation describes status as a way to see task state at a glance. A board can carry up to 100 views, including table, Gantt, timeline, chart, calendar, Kanban, cards and pivot boards. That range makes the same work legible to a project manager, executive or creative lead without asking each person to manipulate a grid.

Its Formula Column is real, useful and more capable than a casual comparison might suggest. It supports arithmetic, dates, text handling, IF statements and nested functions. A formula such as IF({Spent}>{Budget}, "Over budget", "Under budget") can turn two numbers on an item into a decision-ready label. Monday.com also offers syntax highlighting and an AI assistant that can draft formulas.

But Monday.com documents a firm boundary: the formula works horizontally, on the item level. It cannot total an entire column in the Excel sense, pull one item into the formula for another item, or read another board. The company’s support page says a VLOOKUP-style operation across boards is not currently possible inside the Formula Column. Formula output can also require a helper workflow before some automations, emails, charts or cross-board actions can use it reliably.

Smartsheet feels familiar for a different reason. The cell remains a first-class place to express logic. Its function library includes SUMIF, COUNTIFS, IF, IFERROR, INDEX, MATCH and VLOOKUP, plus hierarchy-aware functions such as CHILDREN, PARENT and ANCESTORS. Formulas can be written as column formulas. Sheet summaries can calculate budget, status and health. Named cross-sheet references can pull a range from one sheet into a formula in another.

There are limits. Smartsheet caps the number and size of cross-sheet references, requires the right permissions, and does not allow every hierarchy function to work across sheets. Cells containing cross-sheet formulas also do not automatically trigger certain actions that change a sheet. This is software, not sorcery. The meaningful difference is that Smartsheet treats the cross-sheet formula as a supported native workflow rather than routing the user toward a different abstraction.

Why power users are hard to move

A spreadsheet power user does not merely know where SUMIF lives. She has learned to turn a messy process into a model. A range represents a department. A nested IF represents policy. A lookup represents the handshake between two systems that were never designed to speak. Those formulas are often ugly, but they contain institutional memory.

This is why migration estimates routinely undercount the hard part. Exporting rows is straightforward. Recreating the logic between them is not. A board can arrive intact while the operating model disappears. If the old sheet calculated staffing needs from a rate table on another tab, flags exceptions through layered conditions and feeds a management summary, the destination needs to reproduce the behavior, not just the columns.

Smartsheet’s advantage here is continuity. An Excel-fluent analyst still has new syntax to learn, especially for column names, hierarchy and cross-sheet reference names. Yet the mental model survives: ranges can be tested, filtered, summed and matched. The user can build a metric sheet from other sheets without first translating every dependency into connected-board columns and mirrored values.

Monday.com’s advantage is accessibility across the team. Many colleagues do not want to inspect a formula or understand a range. They want to know what is blocked, who owns it and when it will ship. A carefully designed board can reduce the interpretive labor that spreadsheets impose. The visual status is not decoration. It is an interface for shared attention.

The mistake is pretending that one instinct is universally more modern. A marketing launch with dozens of collaborators may benefit from a vivid board that reveals state without training. A portfolio office consolidating budgets and milestones from many project sheets may value cross-sheet functions more. A team can also use either product beyond its stereotype. Smartsheet has dashboards and automation. Monday.com has formulas, connected boards and mirror columns. The question is where each product makes complexity feel native.

The logic audit teams should steal

Before a procurement demo, ask each finalist to rebuild one live workflow. Choose the annoying one, not the photogenic one. Include at least one exception, one summary, one dependency on data elsewhere and one person who will maintain it after launch. Then watch what happens.

Count the translations. Did a single formula become three connected columns, a mirror and an automation? Did a visual status require a helper column and a report before an executive could read it? Neither answer automatically disqualifies a product. It reveals the maintenance burden your team is buying.

Next, identify the logic owners. These are often the people labeled “good at spreadsheets,” even when their actual job is operations, finance, production or program management. Ask them to annotate formulas in plain language. Which ones make decisions? Which ones prevent errors? Which ones can be retired? A formula inventory will expose redundant process debt as well as genuine requirements.

Finally, price the workaround, not just the license. A platform can look cheaper until the team adds integrations, duplicate helper fields, custom automation and manual reconciliation. The reverse is also true: preserving every inherited spreadsheet trick can make a simpler process unnecessarily complicated. Sometimes migration is the right moment to delete a clever formula and replace it with an explicit status that everyone understands.

Do not migrate the spreadsheet. Migrate the decisions the spreadsheet makes.

A narrow wedge with a long life

Monday.com was founded in 2012 and became a public company in 2021. Smartsheet, founded in 2005, was taken private in January 2025 in an acquisition valued at about $8.4 billion. Both have had time and capital to widen their products. Their overlap will keep growing, especially as AI makes formula creation and workflow building easier.

AI may reduce the effort required to write syntax. It does not eliminate the need for a coherent data model. Someone still has to decide which range matters, where a reference should point, what counts as an exception and who owns the result. Power users stay valuable because they understand those relationships, not because they can remember where every comma goes.

That gives Smartsheet a durable retention wedge. The product lets spreadsheet-trained operators carry more of their existing language into collaborative work management. Monday.com can answer with connected data, workflows and increasingly capable automation, but its Formula Column still asks the user to think within the row and board.

For buyers, the payoff is clarity. Pick Monday.com because a larger group will see and update the work. Pick Smartsheet because the people modeling the work can keep expressing its logic. If both claims matter, test the ugliest workflow before committing. The tool that survives that test is usually the one your team will still trust after the launch deck is forgotten.