how to define who the approval is from multiples

I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests.

We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present once the request is approved, the cell gets populated with "approved" - but I don't know which one of the three people has done it (apart from viewing cell history). Instead of writing "approved" could the cell be populated with the approvers initials?

I have tried individual approval requests which all default to submitted

I can add an "IF" statement for a single approval to generate initials or write "TBC" using the formula: =IF([PA APR]5 = "Approved", "PA", "tbc")

But I cant get it to look at two more columns (see image - I know its wrong, its to give the column titles etc).

My end goal is to take approval initials and send them to a google word doc with mail merge.

Any help would be greatly appreciated.

SMARTSHEET APPROVAL PROBLEM.PNG

Find more posts tagged with

Manufacturing

Formulas

IT & Operations

Product Development

Project Management

Email Notifications

Comments

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround could be to have three Approval Requests (one for each approver) and then depending on who answers the status would change to Approved by CM or similar.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

paldous

Andrée - thanks for responding so fast!

"A possible workaround could be to have three Approval Requests (one for each approver) and then depending on who answers the status would change to Approved by CM or similar."

This is what I'm trying to achieve, but can't get the logic statement to work. I'm trying to get the "approved_by" to show PA, CM or ST depending on who gives approval, or "TBC" if a false statement is required.

Can this be done?

paldous

Andrée - that would be perfect! but how do I get the logic statement to work?

Andrée Starå

Great!

You would use the same column for all approvers and then you can use an IF statement to get the initials of the one that approved.

You'll have to add the different states that you'd want to use and then you'll need to change the Approved save status for each Approver in the advanced settings of the Approval request.

Hope that helps!

Best,

Andrée

Paul Newcome

I use an Update request.

Change your Approved By column to a contact type column.

You can then enter the three different people's contact info and include that column in the update request. Whoever checks the box for "Approved" or "Denied" will simply select their name from the dropdown list (similar to how a form works).

With it being a contact type column, you can also use that column in other alerts and actions to send further update request (if they denied but didn't say why, etc.)

Paul Newcome

To use this...

In Row 1, enter the initials in the corresponding approval column.

Then in your Approved-by column you can use something along the lines of

="Approved by: " + JOIN(COLLECT($[First Approval Column]$1:$[Last Approval Column]$1, [First Approval Column]@row:[Last Approval Column]@row, "Approved"), " - ")

What this does is pull the initials from row 1 for whatever row the formula is in where "Approved" is the status. If only CM approved, it would show

Approved by: CM

If CM and ST approved

Approved by: CM - ST

Etc...........

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…