Checking Done for multiple cells

egrimeegrime ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
10/10/19 Edited 12/09/19

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 NewcomePaul 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 WildayMike Wilday ✭✭✭✭✭

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

  • Mike WildayMike Wilday ✭✭✭✭✭

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

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

    1 = a checked box. 

  • Paul NewcomePaul 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

Sign In or Register to comment.