Hello, I have a sheet with a series of 6 check boxes for different tasks. A team-member checks a box when an operation/task is complete. Some tasks can be done concurrently and are not dependent on another, but I would like to indicate the last completed task up until the next blank check box.
Example 1:
Checkboxes 1-4 are complete, I would like a status column to indicate complete through task 4.
Example 2:
Checkboxes 1,2 and 4 are complete, I would like the status to indicate complete through task 2.
My plan was to nest a COUNTIF with an AND / IF statement for each check box, but I can't seem to figure it out. The first example above would count 4 for each task completed but count 2 for example 2. The formula got pretty lengthy so I won't paste if here unless someone needs it.
Linking the counted checkboxes to the status is not an issue, so I really just need the count formula to work properly. Any ideas would be most welcome.
Thanks all!
