How to calculate a % done across a row?

Options

I'm trying to calculate $ Complete where green = 100% done; the rest indicate not done, 0%

Vendor A = 0% complete (0 green indicators of 6)

Vendor B = 33% complete (2 green indicators of 6)


I appreciate any input :=)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!