Checkbox sum for weighted score

Andrew McCreath
edited 01/14/22 in Formulas and Functions

Hi, unable to wrap my head around this so hoping some smarter folks can help me here, please!


In a row of activities, there are columns with checkboxes. Based on which ones are checked, I'd like to add the score associated with that column/ checkbox


I'd like the end column to total up the number of points based on the boxes checked. (John=10, Jane =8, Arthur=5)

Does that compute?

Many thanks in advance

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!