Forum Discussion
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...
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]
I have created the sheets for a few projects now and formulas work very well, however a couple of issues I've had is the work sheets running quite slowly due to the number of columns and rows we need, but I kind of got around this by having separate sheets rather than workbooks. The second issue is that most users will be onsite using a phone or tablet to complete the sheets and I've found that we cant use Form Control on mobile devices.
Another user has suggested using Yes/No pull down as this eliminates Form Control, then use Card View to make it more compatible. I'm happy with this, but the formula you assisted me with isn't going to work with this. Therefore, can you suggest a formula that essentially does the same thing, but works when yes is selected?
Another user has suggested using Yes/No pull down as this eliminates Form Control, then use Card View to make it more compatible. I'm happy with this, but the formula you assisted me with isn't going to work with this. Therefore, can you suggest a formula that essentially does the same thing, but works when yes is selected?
I have hopes that the Insert/CellControls/CheckBox that is currently out for beta-testing on Windows machines will eventually find its was to other platforms because it is there that they are most needed.
Dropdowns can be set to work with TRUE/FALSE or 1/0, in which case they can be used directly by the existing formulas. If you opt for "Yes"/"No" a slight modification to any dependent formula is required
= BYROW((StatusYesNo="Yes") * {60,20,10,10,10}%, LAMBDA(x, SUM(x)))Note the new name was 'StatusYesNo' was introduced simply because 'Status' is still in use on the original sheet. Something else that should happen sometime over the coming months is that it should be possible to simplify the formula to read
= BYROW((StatusYesNo="Yes") * {60,20,10,10,10}%, SUM)but not yet.
- Thanks Peter, didn't even think about keeping it as True/False! Changed to this and it works perfectly. Even better than before, its a fraction of the size and formatting is much easier.