Can I assign a value to a checkbox(s) that can be added to a total column

Options

Can I assign a value to a checkbox(s) in several columns that can be added to a total column at the end of a row to create a "scoreboard"? See image below.


Best Answer

  • DKazatsky2
    DKazatsky2 ✭✭✭✭✭
    Answer ✓
    Options

    Hi @TroyP,

    You can use the following formula in the "Points Total" column.

    =IF([If checked add 1500]@row = 1, 1500) + IF([If checked add 300]@row = 1, 300) + IF([If checked add 50]@row = 1, 50)

    Hope this helps,

    Dave

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!