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?
