Forum Discussion

CraigPauley's avatar
CraigPauley
Copper Contributor
Feb 15, 2024
Solved

Using checkboxes to create percentage bar

I've seen that you can use Excel to create a percentage bar when using checkboxes. However, is there a way to assign a specific percentage to each check box rather than dividing it by the total numbe...
excel
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Feb 16, 2024

    CraigPauley 

    Including the values on the worksheet to give an alternating pattern is a step backward because it makes any calculation harder.  The formula I would use is

    = BYROW(status * {60,20,10,10,10}%, LAMBDA(x, SUM(x)))

    which spills to return the entire column of overall percentages.

     

    [Look out for the new checkboxes when the come available; they are much better to set up and use]

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Feb 15, 2024

CraigPauley 

Is this the sort of thing you require?

This is just a conditional format, but maybe you have some other strategy for your progress bar?

My checkboxes simply return TRUE or FALSE but the percentage is calculated in the formatted cell using

= SUM(checkMarks * {60;20;10;10}%)
CraigPauley's avatar
CraigPauley
Copper Contributor
Feb 16, 2024

PeterBartholomew1 Thanks.

I've attached a copy of what it is that I'm working with as we literally have hundred of rows for some projects and as such struggled to implement your suggestion, unless I'm missing something? I've now added the percentages in the cells adjacent for my reference and also to possibly assist with a formula?

 

 

 

Resources