Approval Status formula with either 3 of 3 Approvals or 1 of 3 Approvals


I am wondering if its possible to have an Approval Status for different groups of Approvers. Details below

-Approvers 1-3 will require all 3 approvers, change status to "Ready to Create"

-Approvers 4-6 will require 1 approver, change status to "Ready to Create"

-If any 6 Deny the request, change status to "Denied"

I've been trying a few different IF statements, but I'm stumped.

Any help would be appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!