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)
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.
I can get it to run when I manually trigger the rule, but cannot get it to automatically do it. Please help!
Best Answer
-
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?
Answers
-
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?
-
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!
-
Heh you're welcome. That "notify myself" setting is a gotcha. It's so buried and not called out anywhere.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives