Automation Not Working

Hello,

I'm at a loss. I've created several automation rules in the past and I cannot figure out why this is not working for me. I have a simple sheet with the following columns:

Status (single select dropdown)
Sub-Category (text)
Task (text)
Assignee (single contact column)

Screenshot 2024-09-09 at 12.25.07 PM.png

The automation rule is triggered when the Assignee changes to Any Value, where the Assignee is not blank AND the Status is one of Not Started.

Screenshot 2024-09-09 at 12.28.28 PM.png

Screenshot 2024-09-09 at 12.28.37 PM.png

I can get it to run when I manually trigger the rule, but cannot get it to automatically do it. Please help!

Find more posts tagged with

Automations

Accepted answers

Brian_Richardson

Looks like it's setup simply and clearly - no reason it shouldn't run.

I'd check a couple of things:

Are you giving it enough time? Sometimes automations take a surprisingly long time to fire off
Are you setting yourself as the Assignee for testing? If so, then you won't get notifications from this automation unless you go into your Personal Settings and check the "Include my changes in sheet notifications" checkbox.
Are your automation permissions set to Restricted (default), and if so are your assignees shared to the sheet? May need to adjust permissions or sharing to get the notifications out, depending on your audience.
Did you check spam folders? Sometimes my alerts go to spam randomly on Gmail
Did you check the Alerts window to see if the alert is firing, but maybe not making it through email?

All comments

Brian_Richardson

Looks like it's setup simply and clearly - no reason it shouldn't run.

I'd check a couple of things:

Are you giving it enough time? Sometimes automations take a surprisingly long time to fire off
Are you setting yourself as the Assignee for testing? If so, then you won't get notifications from this automation unless you go into your Personal Settings and check the "Include my changes in sheet notifications" checkbox.
Are your automation permissions set to Restricted (default), and if so are your assignees shared to the sheet? May need to adjust permissions or sharing to get the notifications out, depending on your audience.
Did you check spam folders? Sometimes my alerts go to spam randomly on Gmail
Did you check the Alerts window to see if the alert is firing, but maybe not making it through email?

aborder

Hi Brian, I just changed the user settings for myself and it worked! Thank you so much! It was giving me such a headache! You're the best!

Brian_Richardson

Heh you're welcome. That "notify myself" setting is a gotcha. It's so buried and not called out anywhere.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.