# Percentage Formula

I have this formula that calculates the percentage of items in a column where the check box "**Approved to Order" is checked, and it only counts items that have a quantity of 1 or greater than one.

We are moving the check box to a Status column with many options, so I changed the formula but it is not working. Can anyone adjust it for me? Thank you!

=(COUNTIF([**Approved to ORDER]:[**Approved to ORDER], 1)) / (COUNTIF([**QTY]:[**QTY],

=(COUNTIF([Status@row = "Approved to Order"]:[Status@row = "Approved to Order"], 1)) / (COUNTIF([**QTY]:[**QTY], >=1))

I figured it out, thanks!

=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))

• ✭✭✭✭✭

Try this

=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)

I figured it out, thanks!

=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))

• ✭✭✭✭✭

Try this

=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)

• Thanks Devin,

I appreciate the simplified version.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!