Set status when all mirror statuses are done

Set status when all mirror statuses are done

TL;DR: Rollup pattern. When a Mirror status column changes on this board, and only if every Mirror status reflects the value you specify (e.g. "Done"), this recipe sets a target status column to a value you choose. Use it to drive a master record's status from the completion state of all its linked subtasks.

What this does

Recipe: "When mirror status changes and only if all the mirror statuses are done, set status to something."
Watches a Mirror status column on this board (one that pulls statuses from connected items on another board). When any Mirror status changes, the recipe checks: are all the connected items now at the trigger value? If yes, it sets a status column on this board to the value you choose.
It's a rollup: the "master" record's status flips only when every linked sub-record is done (or whatever value you pick).

When to use it

  • Project ↔ Tasks: when all subtasks are Done, mark the project Complete
  • Order ↔ Line items: when all order lines are Shipped, mark the order Fulfilled
  • Account ↔ Tickets: when all open tickets are Resolved, mark the account Healthy
This recipe uses a mirror column as the trigger — not a regular status column on this board. For reacting to a single connected item's status change, use  When connected status changes, sync status⁠ . For all sync variants, see  Sync values between connected items⁠ .

Before you start

  • Items on this board must already be connected via a Connect Boards column (see  Setting up Connect Boards columns⁠  )
  • A Mirror status column on this board pointing at the connected board's status column
  • A destination status column on this board with the rollup value defined (e.g. "Complete", "Closed")

Set it up (3 minutes)

1. Open the Automations Center

From your board, click Automate → Create.

2. Search Connected Boards Automations

Search Connected Boards and pick Connected Boards Automations.

3. Find the recipe

Find the recipe "When mirror status changes and only if all the mirror statuses are done, set status to something." Click Use template.

4. Pick the Mirror status column (trigger)

The Mirror status column on this board that you want to watch. The recipe checks all mirrored values on this column whenever it changes.

5. Pick the destination board's Status label value

Once all connected items are marked "Done" in the other board, the automation will change the item's Status in this board to something. Pick a label that you want.

8. Click Create automation

Test that it works

    Pick an item on this board with multiple connected items.
    On the other connected board, mark all other items that are linked to that item and change their Status to Done.
    Confirm the destination status column on this board flips to the chosen value.
    Mark one linked item back to a non-trigger status — confirm the destination status does NOT change back automatically (this recipe only fires when all-done).

Common gotchas

  • The trigger is a Mirror column, not a regular column. A Mirror column must be set up first on this board, pointing at the connected board's status column.
  • Only fires when ALL items match the trigger value. Partial progress doesn't fire the recipe. If you want continuous progress tracking, use a different rollup approach.
  • Doesn't auto-revert. If a connected item moves back out of the trigger status, the master status stays at the value you set. Use a separate recipe to handle un-rollup if needed.
  • One trigger value per recipe. Mapping multiple rollup states (all Done → Complete, all Cancelled → Cancelled) requires one recipe per pair.
Pair with the status-sync recipe.  When connected status changes, sync status⁠  reacts to a single connected item's status; this recipe rolls multiple mirrored statuses up to a master state. Together they create a full reactive rollup.

Next up

Related

  •  Sync values between connected items⁠  (parent landing)
  •  When connected status changes, sync status⁠  — single-item status sync
  •  When a column changes, sync to connected items⁠  — push values to connected items
  •  Setting up Connect Boards columns⁠  — prerequisite

Still stuck?

Email  hello@fantasymedia.io  and we'll help you configure the right setup for your boards.