OK, I need help with a counting formula -
This example works in Excel, but not in Smartsheet
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.
Help Article Resources
Check out the Formula Handbook template!