Use Dynamic Cell to Trigger Automation isn't working

Matt Suderman

I have 2 sheets. Test Scripts and Test Results

In Test Scripts, I have a lookup that pulls in the Result of the LAST Test Result for that Script. (Fail, Pass)

I have an Automation in the Test Scripts to change the STATUS of the Test Script that is triggered by a CHANGE to the cell that has the Lookup.

When "Last Test Result changes to Pass" Change Status to Pass

That automation is NOT being triggered when the cell changes.

Anybody have any clues?

Andrée Starå

Hi @Matt Suderman

I hope you're well and safe!

This is probably why. You'd have to change it, so it's based on time instead.

To prevent infinite approval loops, cells that contain cross-sheet formulas or cell links will not trigger an automation which automatically changes the sheet (Move Row, Copy Row, Lock Row, Unlock Row, Approval Request). To work around this, consider using time-based automation or recurrence workflows.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!