Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

If statement for checkboxes

Katlyn Lawver
edited 12/09/19 in Archived 2016 Posts

Hey everyone,


     I have project schedules with milestones that have associated tasks for each.  (i.e. releasing a drawing set includes getting it stamped, sending to subcontractors, etc).  I would like to make the tasks a checklist that would populate the percent complete (instead of a harvey ball), using a formula.  Has anyone done this?




  • Atus Bartal
    Atus Bartal ✭✭✭✭✭✭
    edited 06/23/16


    I use something like you are writing about in a row where I have 6 to 8 checkboxes (in 6 to 8 checkbox columns). 

    Let's say you have 10 columns, Check1 to Check10, then the formula is for the first row:

    =COUNTIF([Check1]1:[Check10]1, 1)/10

    Are these "milestones" in one row or in different ones? 



This discussion has been closed.