Automation script not working

rfresh737

2022-03-20_050204.png

When I change my Status column to Cancelled the specified cells do not clear. So what have I done wrong?

Andrée Starå

@rfresh737

There can be a slight delay, and sometimes it needs a refresh.

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

Andrée Starå

Hi @rfresh737

I hope you're well and safe!

First, ensure that you have allowed yourself to receive notifications properly in your Personal Settings (circle/profile in the lower-left corner). Secondly, check the Permission setting for the Automations. (cog in the top right corner in the Automation overview)

Ensure that you've checked the Sheet Change Notification Settings box to Include my changes in sheet notifications in your Personal Settings (circle/profile in the lower-left corner).

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

rfresh737

Thank you Andree for those tips. I set Permission setting for the Automations to Unrestricted and have all notifications for Personal checked. This didn't affect my automation script. When I set a row's Status to Cancelled, it does not blank any of the cells like it should. The Conditional Formatting I have setup does change the row color to orange but the automation script does not work.

Andrée Starå

@rfresh737

Happy to help!

Strange!

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

rfresh737

Share invitation sent.

Andrée Starå

@rfresh737

Thanks!

In your Workflow, you have a condition looking, so it's Cancelled, which is probably why it's not working. Try to remove the Condition.

Did that work?

rfresh737

I removed the Condition but there was no change when I set a row Status to Cancelled. No cells were cleared.

rfresh737

Hold on a minute. When I went back to my sheet from here, the cells were cleared. There seems to be a delay in them clearing.

Yes, the automation script is clearing the cells now (since removing the Condition) but it takes several minutes to see the changes. Seems odd to me there is such a delay when Conditional Formatting is immediate.

Andrée Starå

@rfresh737

There can be a slight delay, and sometimes it needs a refresh.

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

rfresh737

Yes, the Refresh updates it immediately.

Thank you for the help.

Andrée Starå

@rfresh737

Excellent!

You're more than welcome!