Automation and system column
Hello,
We would like to get an email notification with the name of the last person who edited a row in smartsheet. To do this, we have set up the column “Automatic / system numbering” - “Modified by”. However, we have many automations in our grid. So a modification has an impact on different cells. And when the notification reaches us, the last modification was made by: "automation@smartsheet.com".
How can we have the name of the last person to modify the cell without having the "automation@smartsheet.com"?
A big thank you to the whole community,
Answers
-
Hi @CHUMYUSER
How many potential collaborators do you have for this sheet? If you only have a handful of potential people making changes, I would suggest setting up an Assign People workflow which looks at the email address in the Modified column and updates a Contact column with that person's name.
That way when it changes to automation@smartsheet.com, the Contact column will keep the last Contact name so you can use this in an alert. See: Assign People in an Automated Workflow
You can also always check the Cell History in a sheet if you ever need to see who made changes. If your plan has access to it, you may also be able to access the Activity Log of the sheet, too. See: View Changes Made to Smartsheet Items
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives