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

TroyP

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.

DKazatsky2

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

DKazatsky2

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

TroyP

Awesome! Thank you so much!!!