HELP!!!
OK, I need help with a counting formula 
This example works in Excel, but not in Smartsheet
=IFERROR(COUNTIFSG14:K14, “P”)/COUNTA(G14:K14),””)
The goal is to count the number of populated columns in the row only  and get a % in the score column.
if blank, no value 
1 (f) = 0%
1(F) and 1(p) = 50%
1 (p) = 100%
2(p) and 2(f) = 50%
so on and so on.
Tags:
Best Answer

=IFERROR(COUNTIF(G14:K14, “P”)/COUNT(G14:K14),"")
Something like that should do you.
Answers

=IFERROR(COUNTIF(G14:K14, “P”)/COUNT(G14:K14),"")
Something like that should do you.

THANK YOU THANK YOU 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!