Counting yes and yes w/notes

Hello,

I am having trouble counting using the COUNTIFS formula to yes's and another category called "Yes w/notes". Here is the current formula that I have:

• =COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, @cell = "Yes") / COUNTIFS([Are all workers wearing the proper PPE?]@row:[Is there a permit required?]@row, AND(@cell <> "n/a"))

It means mentions "N/A" because I did not want that increasing or decreasing the percentage.

The only categories that should be affecting it are "YES" and "YES W/NOTES" to increase the percentage, but also count "NO" and "NO W/NOTES" to decrease the percentage. But someone selects "YES W/NOTES" it decreases the percentage when it should increasing it.

If someone can get back to me as soon as possible, that would be great.

Thank you

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!