Countifs and checkboxes etc - To Do List

[Andyg666]

Hi,
I am looking at setting up a to do list in excel with checkboxes (currently 25%, 50%, 75% & 100%) I need to count the checkboxes and in a different cell say where the task is at e.g. 25%, 50%, 75% or Done (100%))

I have a =IF(COUNTIF(B2:E2,TRUE)=4,"Done","In Progress") but this only returns two answers - Done or In Progress.

I would also like to use conditional formatting or something like to format the colour depending on the percentage complete.

Link to the file so far is - Tasks - Copy.xlsx

 

[HighAndWilder]

Hi,
I am looking at setting up a to do list in excel with checkboxes (currently 25%, 50%, 75% & 100%) I need to count the checkboxes and in a different cell say where the task is at e.g. 25%, 50%, 75% or Done (100%))

I have a =IF(COUNTIF(B2:E2,TRUE)=4,"Done","In Progress") but this only returns two answers - Done or In Progress.

I would also like to use conditional formatting or something like to format the colour depending on the percentage complete.

Link to the file so far is - Tasks - Copy.xlsx

Use this formula and format the cells as percentages.

=LET(t,COUNTIF($B2:$E2,TRUE),IF(t=0,"",CHOOSE(t,0.25,0.5,0.75,1)))

You could use Data Bars or Color Scaling.

 

[Andyg666]

Use this formula and format the cells as percentages.

=LET(t,COUNTIF($B2:$E2,TRUE),IF(t=0,"",CHOOSE(t,0.25,0.5,0.75,1)))

You could use Data Bars or Color Scaling.

Thanks,
Not 100% what I was after and I couldn't get the data bars to work for me but it could work.

 

[HighAndWilder]

Thanks,
Not 100% what I was after and I couldn't get the data bars to work for me but it could work.

So what do you want that is different?