What we do
Tools
Industries
Department
How we workLet's talk →
Home/Smartsheet/Smartsheet Workflow Automation That Keeps Firing
Smartsheet

Building a Smartsheet Workflow, and Finding Out Why One Stopped

A due-date reminder that used to arrive every Monday hasn't come in a month, and no error ever showed up. That's normal for Smartsheet's Automated Workflows: when a condition stops matching, the workflow simply has nothing to do. Every workflow is a trigger, optional conditions, and one or more actions, built visually, on Pro, Business and Enterprise.

Where Smartsheet workflows live

New workflow: open the sheet in Table View, click Automations on the toolbar, then Create from scratch in the upper right.

Automations Create from scratch

From a template: same menu, pick a template, then Use template. Reminders and approvals both have one.

Automations Use template

Who can build them: Owners, Admins and Editors. Editors can only create or change alerts and reminders that go to themselves.

Why a Smartsheet workflow ran fine, then went quiet

Open the workflow next to the sheet and check its references against what the sheet looks like today.

The value changed through a cross-sheet formula or a cell link

How you'll know: A status set by a formula from another sheet flips to Complete, and the Move Row or approval never happens.

Fix: Changes that arrive by cell link or cross-sheet formula don't fire actions that change the sheet, which Smartsheet does to stop loops. Use a date-based or recurring trigger that checks the value instead.

The condition no longer matches real data

How you'll know: Someone renamed a status from "Approved" to "Signed off", or added a new option the condition doesn't list.

Fix: Rewrite the condition against today's values. A condition block holds up to 20 statements, so an "is one of" list usually covers the variants.

The date column is empty

How you'll know: A reminder fires for some rows and never for others.

Fix: A date trigger skips any row with no date in that column. Make the column required on the intake form, or add a filter view that shows rows missing a date.

The recipient left

How you'll know: Alerts go to a person, not a contact column, and that person's account was removed.

Fix: Send to a contact column on the row, so the right person gets it when the row's owner changes.

Batching is holding it

How you'll know: The approval request turns up hours or days late.

Fix: Hourly, daily and weekly batching only applies to notifications and update or approval requests without If approved or If declined steps. Set it to When triggered for anything time-sensitive.

Trigger, condition, action: assembling the Smartsheet workflow

  1. 1

    Choose what starts it

    Four choices: when a date is reached, when rows are added or changed, when rows are changed, or when rows are added. A date trigger can recur daily, weekly, monthly or yearly, or fire a set number of days before or after a date in a column.

    Watch for: "When rows are added" ignores later edits. If a row is created empty and filled in afterwards, use "added or changed".

  2. 2

    Narrow it with conditions

    + Condition

    Conditions decide which rows count: a status, a priority, an amount over a threshold. Add a condition path when different rows should get different actions. Overlapping paths are checked left to right, and only the leftmost match runs.

  3. 3

    Choose the action

    + Action

    Send an alert or reminder, request an update, request an approval, or change the sheet itself with Move Row, Copy Row, Lock Row or Unlock Row. An approval can branch on approved or declined, so a sign-off can move the row and alert the next person.

  4. 4

    Label it so you'll know it in six months

    Give it a name that says what it does and which column it watches. If it stops working down the line, that name is the first clue.

    Watch for: every path needs at least one action at its end, including condition paths you added as a fallback.

Smartsheet workflow limits worth knowing before you build

Limit Number What it means in practice
Workflows per sheet 150 A sheet past a few dozen workflows is hard to audit. Group related reminders into one workflow with condition paths.
Blocks per workflow 100, of which 30 can be actions Long approval chains run out of action blocks before they run out of steps.
Statements per condition block 20 Enough for most status lists. Past that, a helper column with a formula is easier to maintain.
Attachment links in workflow emails Expire after 14 days Anyone opening an old alert gets a dead link. Point them at the row instead.

After the approval clears: the step Smartsheet hands back to a person

Every action above stays inside Smartsheet. It can email someone, lock a row or move it to another sheet, but it can't raise the invoice in your accounting system, mark the deal won in your CRM, or open a purchase order in your ERP. So the approval clears, and someone copies the numbers across by hand.

n-frames builds that last step on the Smartsheet API: a sheet webhook sees the row change to Approved, the service writes the record in the other system, and the new invoice or order number is written back to the row so the sheet shows it happened. For very large or many-system processes, Smartsheet's Bridge add-on is an option, compared on our Smartsheet integrations page. And because a workflow that stops matching never errors, we add a check that tells the sheet owner when one hasn't run in longer than it should.

Questions people ask

What is an automated workflow in Smartsheet?

Smartsheet's built-in automation: a trigger such as a row added or a date arriving, optional conditions that pick which rows count, and actions like an alert, an update request, an approval request or a Move Row. It's built in the Automations menu without code, on Pro, Business and Enterprise.

Why isn't my Smartsheet automation working?

Most often a condition that no longer matches the data, a change that came in through a cross-sheet formula or cell link, a row with no date for a date trigger, a recipient who left, or batching that's holding the message. Check each against the sheet as it is now.

Can Smartsheet send automatic email reminders?

Yes. Use a "When a date is reached" trigger, pointed at a date column and set a number of days before or after it, or on a recurring schedule. The reminder goes to a person, a group or a contact column on the row.

What is an approval workflow in Smartsheet?

A workflow whose action is an approval request. The approver gets the row and chooses approve or decline, and the workflow can then branch: update a status, move the row, or alert the next person in line.

Can a Smartsheet workflow update another system?

A workflow alone can't: its actions stay in Smartsheet. Reaching a CRM, accounting or ERP system takes a connector, Bridge, or a small service on the Smartsheet API, which is the part n-frames builds and keeps running.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.