COUNTIFS ISSUE
Options
C.Beaudoin
✭✭✭
I'm hoping someone can help. I am trying to use a COUNTIFS formula to count only if "Final Verification" is Gravoc AND "Verification %Complete" is set to 100%. I am getting stuck and it gives a result of 0. I have attached a few screen shots below. I have even tried using @cell inserts...
Best Answer

Instead of writing "100%" you should just put 1.
Answers

Instead of writing "100%" you should just put 1.

Ahh, yes thank you!!
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!