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.

Find more posts tagged with

Accepted answers

kowal

hi @HRR

try this:

=IF(AND([Approver 1]@row = "Approved", [Approver 2]@row = "Approved", [Approver 3]@row = "Approved"),"Approved", "Not Approved")

shall work now.

All comments

kowal

hi @HRR

try this:

=IF(AND([Approver 1]@row = "Approved", [Approver 2]@row = "Approved", [Approver 3]@row = "Approved"),"Approved", "Not Approved")

shall work now.

HRR

I'm still getting the #Unparseable message. Any other thoughts?

HRR

I had a typo, it is working now. Thank you for the assistance.

Andrée Starå

https://community.smartsheet.com/discussion/139574/how-do-i-update-a-status-based-on-3-different-approvals

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.