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

HRR
HRR ✭✭✭

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!