Percentage with Multiple Criteria



I want to see if there is a more efficient formula to do this.

There are multiple order lines and I want to find out what the percentage of shipped items for that order, but it seems like a slow formula. Any thoughts on how I can make this better?

=IFERROR(COUNTIFS([Sales Order #]:[Sales Order #], [Sales Order #]@row, [Shipped Complete]:[Shipped Complete], @cell = "Yes") / COUNTIF([Sales Order #]:[Sales Order #], [Sales Order #]@row), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!