Grouped Update Requests
I am looking for a way to send multiple update requests in a single email.
Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Then I want Smartsheet to automatically send out an update request to our shipping department telling them to go ahead and send the product. This update request needs a way for the shipping department to respond saying the product has been shipped.
This works fine if there is just one product being inspected. I can use the 'When Triggered' option in my automation. The problem is when I have 15 or 20 items being checked each hour. The shipping dept. gets inundated with emails. But Smartsheet automation does not allow me to run an Hourly or Daily workflow when requesting an update.
Is there a different way to allow the recipient to respond to a notification that doesn't require them to go into Smartsheet? I don't want them to have access to my main sheet.
Thanks for any and all suggestions!