Returning 3 results for approval results from multiple Approvers


Hi Everyone - First community post!

I'm trying to work out a formula for the below scenario:

I have an approval workflow set up for 10 approvers to one request.

If everyone approves, I want to return a result for "All Approved"

If everyone declines, I want to return a result for "All Declined"

If no consensus is reached (e.g. 7 approve, 3 decline) I want to return a result for "No Consensus Reached".

I've played around with nested IF statements but cannot get close to what I require, does anyone have any suggestions?

Thanks all :)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!