Counting Number of Boxes Checked in a Single Row

Options

Hi all!

I am wondering if there is a way to count the number of times a box has been checked in a single cell. For example, I have a row that shows the years that an employee participated in a program (2015-2022). You can select multiple because they can stay in this program for many years. Then I would want a formula to count how many times they were in the program from that single cell of checked boxed. So if I checked that they were in the program 2019, 2020, 2021, 2022 - I would want the formula to show that the total number of years that they participated was 4 years.

Does anyone know if that is possible or have tried it for themselves? TIA!

Tags:

Best Answer

  • JayCee
    JayCee ✭✭
    Answer ✓
    Options

    Nevermind, I was going to delete this but figured i could leave the very simple answer in case others are looking. :)


    You can use a simple COUNTM on the column to display the results. So in the column that you want to total displayed you would input =COUNTM([Year Participated]@row). Thanks all!

Answers

  • JayCee
    JayCee ✭✭
    Answer ✓
    Options

    Nevermind, I was going to delete this but figured i could leave the very simple answer in case others are looking. :)


    You can use a simple COUNTM on the column to display the results. So in the column that you want to total displayed you would input =COUNTM([Year Participated]@row). Thanks all!

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hey @JayCee

    Thanks so much for coming back and posting your solution! I'm glad you found the right function for what you needed. 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!