Automation for Changes made by a particular user

Hello,

Is there an automation option that allows a notification to be sent if a particular user makes any type of change? For example, User A can make changes to the sheet without triggering the notification, but if User B makes a change a notification is sent.


Thanks

Answers

  • Paul H
    Paul H âś­âś­âś­âś­âś­âś­
    edited 01/28/22

    Add a Auto-Number/System Column for "Modified By"

    put the users email instead of "automation@....."


  • Jeff Reisman
    Jeff Reisman âś­âś­âś­âś­âś­âś­

    @Miles Allison

    If you don't already have it, add the system column "Modified By" to your sheet and save the sheet. Set up your Alert automation, add your trigger for the automation to be "When rows are changed" or "When rows are added or changed," and in the Conditions, add a condition that "Modified By" is not one of <select your users that should not be notified.> (Alternatively, you can set it to only send the Alert if the Modified By IS one of the selected users.)

    I tested this out by changing some rows as me, and then changing others while logged in with my personal "free user" account. I only got alerts for changes by my free user account.


    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!