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.
