How do I update a status based on 3 different approvals.

I have 3 different approvers for work. I want to update a status field so that I can send out an automated email to alert the next person in workflow. Here is where I'm at.
=IF(
("[Approver 1]@row = Approved" and "[Approver 2]@row = Approved" and "[Approver 3]@row = Approved"),
"Approved")
I keep getting the message #Unparseable.
It would be really great, if someone Denied the request the field would update to Denied.
Best Answer
-
hi @HRR
try this:
=IF(AND([Approver 1]@row = "Approved", [Approver 2]@row = "Approved", [Approver 3]@row = "Approved"),"Approved", "Not Approved")
shall work now.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Answers
-
hi @HRR
try this:
=IF(AND([Approver 1]@row = "Approved", [Approver 2]@row = "Approved", [Approver 3]@row = "Approved"),"Approved", "Not Approved")
shall work now.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
-
I'm still getting the #Unparseable message. Any other thoughts?
-
I had a typo, it is working now. Thank you for the assistance.
-
Hi,
I hope you're well and safe!
To add to Tomasz's excellent advice/answer.
Another option could be using Workflows instead; you don't need formulas.Also, a method I use if the Approvers are beside each other is to count the approvals instead.
=IF(COUNTIFS([Approver 1]@row:[Approver 3]@row, "Approved") = 3, "Approved", "Not Approved")
I hope that helps!
Be safe, and have a fantastic day!
Best,
AndrΓ©e StarΓ₯ | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD
β Did my comment(s) help/answer your question or solve your problem? Please support the Community and me byΒ marking it - Insightful π‘- Vote Up β¬οΈ - Awesome β€οΈ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!