Checking Done for multiple cells

egrime

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)

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"?

Mike Wilday

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

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

Mike,

 

My thoughts exactly. 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.