Checking Done for multiple cells
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)