Formulations

Options

Hello,

How do I create a formula that add only checked boxes in a column? I have 4 different columns that have a checkbox to indicate (50k, 100k and 300k thresholds and above 300k) I could not figure out how to calculate how many in each column that have a blue check mark per month. Thanks!

Also,

I wanting to create a approval cycle time in my dashboard but was also unsure. Please assist, I'm still learning how to use this wonderful tool. Thanks!


Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Nkeiruka. Aguocha

    I'm happy to help. One approach is to use a summarized Report. You would need to add a helper column to find the month number so you could group on month number. Here's the formula for month number

    =MONTH([your date column]@row)

    In the report, you would add your 4 checkmark columns (the primary column is automatically added). You would group by the helper column Month and in the Summarize section, you would add each column and COUNT. Here's an example of what that report would look like.

    Does this approach seem like it would work for you?

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!