Sign in to join the conversation:
Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.
This should do the trick. Checkboxes use the actual value of 1 for checked and 0 for unchecked. You can divide the two countifs with simple math like seen below.
=Countif([column name]:[Column Name], 1) / Countif([column name]:[Column name], 0)
So if your column name is Completed Task then it would look like this:
=Countif([Completed Task]:[Completed Task], 1) / Countif([Complete Task]:[Complete Task], 0)
Thank you so much, that works perfect. Now I need to divide by the total number checked by the total number of boxes containg both checked and not checked. I'm so close but no cigar at this point. Any suggestions?
wouldn't it just be
=Countif([column name]:[Column Name], 1) / (Countif([column name]:[Column name], 0) + Countif([column name]:[Column name], 1))?
Also, the denominator is basically all so you could do a count rather than a countif ... but I think this formula is what you were describing
The formula dividing the total number into the number of checked is...
=countif([column name]:[column name], 1) / count([column name]:[column name])
The count function counts all unblank cells in the range.
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
Hello SmartSheet Community. I have created a report with various categories and totals. I wanted to capture certain categories and their totals however the totals are not calculating correctly. I would have to copy the totals, paste them to an excel blank sheet and AutoSum there. Can someone see what I am doing wrong?…
I need help creating a formula to calculate how many hours my team is allocated for per week. I have three columns in my sheet that we use for task management. Hrs per week - is a number on the hours it takes Assigned to - is a manual text field of the team member who is doing the task Due Date - when it is due (typically…
