Can one cell change cause workflows in multiple grids?

Ray Jacobs

I'm trying to move data from two grids (Grid #1 and Grid #2) using workflows (When rows are changed) to archive grids when a cell is ONLY updated on Grid #1.

Here is my setup and what the issue I'm having…

1. Grid #1 has the column that is being updated.
2. Workflow setup on Grid #1 to move the row when the cell is changed to a specific value. Row is being moved to Archive-Grid #1.
3. I have an INDEX (MATCH) setup on Grid #2 to update the column when it is changed on Grid #1
4. Workflow setup on Grid #2 to move the row when the cell is updated by the INDEX (MATCH). Row is being moved to Archive-Grid #2.

Issue….

When the cell is updated on Grid #1, the row is properly moved by the workflow to Archive-Grid #1, BUT….on Grid #2 I get the NO-MATCH and the row is NOT moved to Archive-Grid #2.

Is there a way that I can use the workflows to move data from multiple grids when the cell is only changed on one of the grids? Or maybe another way of asking is can a Cross Sheet Reference cause a workflow to run?

Paul Newcome

You cannot trigger an automation by a formula using a cross sheet reference. You would need to change the trigger to run daily with a condition of the box being checked. If this is not frequent enough, you can set up additional automations to also run daily but at different times up to as frequently as every hour.

If this STILL is not frequent enough, you would need to leverage the API, the premium add-on Bridge, or some other similar third party app.