HELP!!!

Brian_Anderson_Vegas

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.

L_123

=IFERROR(COUNTIF(G14:K14, “P”)/COUNT(G14:K14),"")

Something like that should do you.

L_123

=IFERROR(COUNTIF(G14:K14, “P”)/COUNT(G14:K14),"")

Something like that should do you.

Brian_Anderson_Vegas

THANK YOU THANK YOU THANK YOU!!!!