Automation Trigger "When Rows are Changed" not working

edited 12/09/19 in Using Smartsheet
06/13/19 Edited 12/09/19

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?????

pic.gif

Comments

  • And I should mention that I am hitting the "save" button smiley.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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 PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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.

  • Mike WildayMike Wilday ✭✭✭✭✭

    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. 

    yay.gif

  • THANK YOU!  That did it. I knew nothing about that setting. Thanks again.

  • Mike WildayMike Wilday ✭✭✭✭✭
    edited 06/13/19

    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. laugh

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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 PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • I was adding them through a form, which I think bypasses it.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Ok.

    I'll try to see if I can replicate it. Could be a bug.

    Best,

    Andrée

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • 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

  • Hi @Sonia Leijenaar

    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

  • Hi @Genevieve P.


    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

Sign In or Register to comment.