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

Options
pris
pris ✭✭✭✭
edited 12/08/23 in Formulas and Functions

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!