Automation triggered to send to contacts in a cell, but it's still sending to me.
I have an automation set up so that when a rows are added or change and a box is checked it triggers the automation to send to contacts in a cell. However, I keep getting notifications sent to me for one of the triggers, but my email is no longer listed. I wanted to test my automation with my own email first to make sure I liked how it looked, etc. Once I'm satisfied then I switch who it's sent to. My email is not listed as a contact in any cells. I have not continued to check/uncheck the boxes for the trigger, but each time I save my sheet it's sending me an update.
- I just want to make sure this notification is getting sent to who I need it to.
- I also don't want to have sent it to the same person multiple times at this point.
Any ideas why it won't stop sending to me even though my email isn't listed there? It's possible I have competing automations, but even the other automations don't have my email listed.
Answers
-
Are you abel to provide a screenshot of the automation that is sending to you?
-
@Paul Newcome Yes, I've included the screenshot. I might have answered my own question. If one of the contacts in the cell it should be sending to is blank, does it default to the sheet owner? Additionally, I changed it from "When rows are changed or added" to "When rows are changed".
-
It shouldn't send to anyone if the cell is blank. Is that the only automation in the sheet?
-
Hmmm.... weird.
No, it's not the only automation. I have several automations with different conditions. I have one that's identical to this one, except that instead of it sending an automation when triggered I have it set up to send three days in advance of a particular column date. The only reason I created the one in the screenshot is because I needed to send out the notification immediately and it was already less than 3 days before the triggered date column.
I have additional automations (all very similar), but they all show that the send automation to contacts in specific cell and I'm not listed.
-
Hi @BethWork
I hope you're well and safe!
Have you double-checked the other workflows and checked when they ran last as a clue as to what could cause the issue?
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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Have you tried a CRTL+F to search for your name in the contact columns? If you allow multiple contacts but the cell is not large enough (due to a little glitch in the system), a name may not necessarily be visible even if it is still there.
-
@Andrée Starå I did check the other automations and one of them ran at the same time as this one because it's a similar trigger with slightly different conditions. The other automations last ran two days ago.
@Paul Newcome Yes, I double checked for my name/email address on the sheet and it does not appear anywhere.
-
Was that the issue?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå No, that didn't appear to be the issue. Originally, one of the cells that it was supposed to be sending to did not have a contact listed. After I listed a legitimate contact it seemed to have stop sending to me. Even though someone else said it doesn't send to anyone if a cell is blank that's the only thing I can think of that would have changed to help.
-
I leverage blank cells not sending to anyone on a regular basis, so it almost sounds like there may have been a little bit of a bug somewhere.
-
Strange!
Glad you got it working!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Paul Newcome That's what I'm thinking, too. I appreciate the help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives