Attaching entire sheet of specific rows to a notification...

Odd problem but for example I would have a sheet of subprocessor vendors that includes a category, name, address, business line and other fields, when I add a new vendor to that list I would like to notify the customers who have requested that information of the new vendor name, address and category only, as well as all of the other rows name, address and category. Something to the effect of " A new vendor has been added {{New row Name, address and category}} The existing list has been provided as well for reference. This would include all the others on the sheet with just those columns. I've not found any way that i can tell to do this even if we eliminated the desire to only send specific columns and sent all of the columns. We would not want to send them a list to the sheet as they would not have access to the entire sheet. Any suggestions? It would be great to have the new row as a trigger perhaps and then that trigger would send a report that we have created with only the specific columns in it.
Answers
-
Try the solution described below:
Add two new helper columns, one summary field and two automation workflows :
- New row column: when a new row added, New row will be set to 1 using a Change Cell Value automation workflow (Indicating New Row automation).
- Indicating New Row automation workflow
- Alert summary field :
Formula :=SUM([New row]:[New row])
- Alert column :
Column formula :=IF(Alert# = 1, 1)
- Alert workflow: triggered by the Alert value, then notifies people based on selected columns. After sending the Alert, the workflow will clear the New Row value to reset the process.
Logic : when a new row added (eg. Vendor 6), the New row value will be set to 1. This will set the Alert summary field to 1, then set Alert value on all rows to Checked >> Alert people as below
I hope this will work for you.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives