Reusing the same automation on the same triggered cell only works once
I have a simple automation - If a Status cell changes to red or green then trigger.
It works fine unless I try to trigger it again by forcing a change on the cell. I thought it was because cells are locking but I unlocked them and the problem was still there. "Status" is set by checking the values of a group of other cells.
Is this by design for SS or is there some issue I am not aware of?
This is all part of a bigger scheme of world domination that I am building... any help is appreciated.
@Andrée Starå This tacks on to the earlier question about approvals between sheets that you graciously answered, which has led down this path to interacting between the automation and the sheets. Thanks for your guidance thus far !! :)