Automation Trigger "When Rows are Changed" not working
![DevinD](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have been banging my head on this. I need to set up a very simple trigger that when a cell is updated, a notification is sent about that row. I am using the "When Rows are Changed" trigger and defining my cell condition, and filters. I have also tried the "When Rows are added or changed" trigger with no success. I have yet to receive any notifications. I seem to only get notifications when I use the "When Rows are Added" trigger and add a new row. Those come through just fine.
I have boiled this down to a simple test (see attached screenshot) - to send a notification when any cell is changed. I still get nothing. Are these triggers working for anyone?????
Comments
-
And I should mention that I am hitting the "save" button
.
-
Hi Devin,
How are your permissions set up? What change are you making on the sheet that should trigger the Automation?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
At the moment, it is not shared - only I can view (I am still building the sheet out). But I am sending the notifications to myself so I wouldn't think it would matter. And again, I receive notifications when the trigger type is "new rows are added", but nothing else.
All kinds of changes. I have tried changing multiple cells of multiple data types - Changing dates, changing text, changing text boxes.
-
Have you tried checking your personal settings for notifications on changes you make to the sheets? Navigate to Usermenu > Personal Settings > Notificatiosn and make sure the box is checked for Include my changes in Sheet notifications. See screenshot for example.
-
THANK YOU! That did it. I knew nothing about that setting. Thanks again.
-
You're welcome. It's a common experience. I once fell victim to that checkbox myself. It drove me mad. But it makes sense for everything but the setup and testing of the functionality of alerts and reminders.
-
Easy to miss!
I didn't think of it because you were getting notifications for new rows, but I suspect that you didn't add them yourself, right?
Best,
Andrée
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.
-
I was adding them through a form, which I think bypasses it.
-
Ok.
I'll try to see if I can replicate it. Could be a bug.
Best,
Andrée
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.
-
I know this post is very old, but I'm having the same issue. I have unchecked and rechecked the notification options, and have received an "update request" email, but my automation still doesn't work. I have both date triggered and action triggered workflows, and they are incredibly simple -> when Status changes to Completed, change the % completion to 100 (for example). Any ideas? My sheet is shared to all users as well
-
How is the Status column being populated, is this a manual change or done through a formula? Can you post a screen capture of your workflow set-up along with your sheet in grid view (but please block out sensitive data)?
Thanks!
Genevieve
-
I'm actually experiencing a similar issue. I've created automation that reads 'when a new row is entered' and 'row ID' changes to anything, then alert X.
It works if I submit via a form, but last week when I entered in 8 entries manually, after hitting save, it didn't notify anyone.
Attached are screenshots, if that helps.
-
Just to add that the update request icons on the left are because I manually added update requests a few days after the fact.
-
Hi @David Acord
My apologies for the delay in response!
I see in your workflow that the trigger is "when rows are added". Is it possible that when you manually created rows, you filled in a row that previously used to have information which was then cleared out instead of deleted?
If a row used to have information but the content was simply erased, then this row wouldn't be seen as a "new row" so the information you put in would have been an "update" not a new addition. You can check this by looking at the Cell History to see if previous content had been stored there.
Let me know if this was the possible reason!
Genevieve
-
Mike Wilday, I just experienced this issue as well. Your assistance lived on, and you solved my problem! Thank you!😀
Categories
- All Categories
- 14 Welcome to the Community
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives