Reusing the same automation on the same triggered cell only works once

Shane Klos

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 !! :)

SoS | Dan Palenchar

Try changing your automation settings to unrestricted. Seehttps://help.smartsheet.com/articles/2476586-control-who-is-notified-about-alerts-and-requests.

The alert to your Developer in the declined step of the approval workflow at the end is giving you an info message saying some recipients might not get notified due to permissions, so it's possible this is what is preventing the notification from going out.

As written, your automation should function based on a Status change of any value to Red or Green where level is equal to 99. You can also test it by adding your own email to the automation change to make sure it does go out.

Shane Klos

Thanks for your answer Dan. Unfortunately that's not the root cause here. The automation runs fine the first time through and populates the "Approval Status" field as requested and sends notifications accordingly. I did change it to unrestricted and ran some tests on it but it made no difference.

Thank you so much for looking at this for me. All ideas are still welcome though :)

Shane Klos

It seems that the key to this is the initial trigger in the automation - it specifically relates to "row changes". This means that the first time through there is a "new value" / change and the automation triggers but on subsequent changes - unless that first "change" (ie any change elsewhere in the row) is registered the automation won't run. What's important to note here is that a change in value based on an external sheet reference/formula does NOT register for this second change.

Looks like am back to stringing together multiple approval columns and status checks.

And I though this would be simple! LOL