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
-
Add a Auto-Number/System Column for "Modified By"
put the users email instead of "automation@....."
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!