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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!