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))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!