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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!