Checking Done for multiple cells

egrime
egrime ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi! I am trying to find a formula to check a box Done when several other cells are checked done. 

Such as Master Task=done when Task 1, Task 2, Task 3 and Task 4 are checked done.

My If Then formula doesn't seem to work. Any thoughts?

=IF([Column2]1 = "Done", 1, 0)

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are the tasks in different rows of the same column or different columns of the same row? Are they all checkboxes, or are there some that are the actual text of "Done"?

    thinkspi.com

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Also... is Column2 the actual name of your column? Smartsheet references the actual names of your headers. 

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Also, If [Column2]1 is a checkbox your formula should be... 

    =IF([Column2]1 = 1, 1, 0) 

    1 = a checked box. 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Mike,

     

    My thoughts exactly. yes That's why I asked if they were all checkboxes. I wanted to make sure we got it right in case it were maybe a status dropdown type of thing going on.

    thinkspi.com