Is it possible to create a column formula that converts "true" checkbox to value?

pris

I have a sheet that when a column is checked, I would like it to become a value that can be summed. Is it possible? I have a sheet that people can select if they attended several trainings by checking the box of the trainings they attended. I then want to add together the total hours for the training by giving the checkbox a value and summing the columns. If this is not possible, I am open to structuring my sheet differently. I set up an automation to change the value but it cannot be summed because it is a checkbox field. Here is a link to the sheet https://app.smartsheet.com/b/publish?EQBCT=aa235c24a84a4afe92a2c619e094c2f2

Thank you for your help!

pris

Andrée Starå

Hi @pris

I hope you're well and safe!

Double post?

I am answering here, too.

Unfortunately, you need something indicating that it's a parent row. Do you have anything else you could use, like something in the name or similar?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!