approval automation sending multiple emails

I have a smartsheet with a couple automation rules set up to email PM's about submittals. My "request an update" rule runs nicely and sends a single email to the PM with MULTIPLE requests when they click the form in the email.


However, my "request an approval" email sends a single email for EACH item to be approved, which is resulting in multiple emails that a PM has to click through - a real pain for the user.


Is it possible to have the "request an approval" automation rule send a single email with multiple approval requests in it?

The problem emails:



the user has to click through on EACH email which is a huge pain in the butt:



In my other rules that are "request an update" based, I get a nice single email which asks the viewer to go and update the fields. Is it possible to have this format of email come with an approval based rule?

I like the approval email because the user just clicks the button Needs changes/Sent for submittal instead of having to click the row and select the field. It's a small thing but we have a lot of submittals and I want to keep the PM's clicking to a minimum.


Tags:

Best Answer

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    Hi

    As each approval is based of its own row, I don't believe its possible for a consolidated email to be sent.

    We overcame a similar issue by creating a separate report for each PM that would pull through rows that required their approval, they would receive a alert from the main project sheet when a new item required their approval using the standard 'Message Only' automation, which would include a link to the report in the text.

    Beauty of this is you can consolidate alerts not only by project but across multiple projects, assuming each project sheet has the same format you can pull approvals into one report from different projects.

    Hope this may be of help

    Paul McGuinness

Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    Hi

    As each approval is based of its own row, I don't believe its possible for a consolidated email to be sent.

    We overcame a similar issue by creating a separate report for each PM that would pull through rows that required their approval, they would receive a alert from the main project sheet when a new item required their approval using the standard 'Message Only' automation, which would include a link to the report in the text.

    Beauty of this is you can consolidate alerts not only by project but across multiple projects, assuming each project sheet has the same format you can pull approvals into one report from different projects.

    Hope this may be of help

    Paul McGuinness

  • @Paul McGuinness our format is basically a glorified excel right now, it is a single smartsheet that we are putting each projects submittals onto.


    I am looking at the reports and I would like to filter them by PM (i.e. PM "a" gets their own report, PM "b" gets their own report...)


    is there a way to do this using the filters or do I have to create a report for each PM...? I have at least 15 PM's so this is getting into a lot of reports.