Formula for %Complete Column (or progress bar) for 5+ Checkboxes columns

Options

Hi!

I am looking for a formula to either give a percentage complete or similiar from a number of checkboxes.

I have tried;

=COUNTIFS([T1]@row1]:[T7]@row1],=1) - results in UNPARSEABLE

=COUNTIF([T1]2:[T7]2, "True") / COUNT([T1]2:[T7]2) = 0

=COUNTIF([T1]2:[T7]2) / COUNT([T1]2:[T7]2) = incorrect argument set




Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Emma1516156165,

    The formula to use here for counting the checkboxes is:

    =COUNTIF([T1]@row:[T7]@row, 1)

    If each stage is equally weighted, then you can add a divisor and make your column a percentage with this formula:

    =COUNTIF([T1]@row:[T7]@row, 1)/7

    Example:

    Hope this helps - if you've any questions then just ask! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!