Check box and progress bar depending on...

[grumpytrashpanda]

Hey there! I've been struggling trying to find how to describe what I want to do succinctly enough to Google it, so hopefully someone here can help me.

I'm creating a "To-Do" list spreadsheet that keeps track of the percentage of tasks completed.

As you can see, I've managed to link the check boxes to another cell to show progression of tasks completed. My problem is that on days when I only have 6 tasks to do, I want to the progression to reflect those 6 tasks completed as 100% and to disregard the check boxes that are next to empty cells.

I hope that makes sense?

Any ideas at all would be amazing. Thank you so much!

 

[MountainFog]

How did you get it to calculate the %? Are the checkboxes tied to the cell?

 

[grumpytrashpanda]

I right clicked on the check box, went to "Format Control", clicked the cell the check box was in, and hit okay. For the cell that shows the percentage, I used the formula =COUNTIF(B5:B31,TRUE)/COUNTA(B5:B31)

I have a feeling the change I need to make is to the part after the "/".

 

[MountainFog]

Pounded my head against the wall for a bit, before realizing the simpler solution. Change the second half of your formula to count text in column C. Note if there is a box checked in a row that doesn't have a task, it will mess with your percentage.

 

[grumpytrashpanda]

Would you mind writing out exactly what the formula may be, please? Thank you!

 

[dreid1011]

Would you mind writing out exactly what the formula may be, please? Thank you!

Just change the column reference in the COUNTA portion you posted to C5:C31 instead of B5:B31.

 

[grumpytrashpanda]

OMG! That was so easy. Thank you so much!