Use Dynamic Cell to Trigger Automation isn't working

Matt Suderman
Matt Suderman ✭✭
edited 02/16/23 in Smartsheet Basics

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?