My COUNTIF formula is returning 0 instead of the correct decimal value. What am I doing wrong?
Options
Bradhickswa
✭✭✭✭
Hi,
I am using this formula in a supporting sheet to calculate readiness for a task, but I keep getting zeros no matter what...
=COUNTIF({Cross-site IHA Yes}, 1 / COUNTIF({Cross-Site IHA Ask 1}, 1))
Essentially this is saying, count all the "checked" boxes in column 1 and divide them by the number of boxes "checked" in column 2.
Thanks!
Tags:
Best Answer
-
=COUNTIF({Cross-site IHA Yes}, 1) / COUNTIF({Cross-Site IHA Ask 1}, 1)
Answers
-
=COUNTIF({Cross-site IHA Yes}, 1) / COUNTIF({Cross-Site IHA Ask 1}, 1)
-
@Leibel Shuchat I forgot to close my first statement! Silly me.
Thanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!