Percent of Checked Boxes

Options

Struggling to come up with a formula to show percent of boxes checked.

Column Name = Task Complete

Column Type = Checkbox

Need to determine % of tasks complete (checked)


Answers

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    Options

    Hi @MTaylor,

    The "Config Done" is a checkbox column, so expected value will be 0/1 (boolean) not a text value. So you should calculate your % of tasks complete (checked) in another text/number column or in a sheet summary field.

    No need to use SUM, just modify your formula :

    =COUNTIF(CHILDREN([Config done]1), 1) / COUNT(CHILDREN([Config done]1))

    Hope it works.


    Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!