Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
Hi Smartsheet Community, I'm working on an action management system where users create sub-actions through a Smartsheet Form. The requirement is simple: a sub-action's due date must be earlier than or equal to its parent action's due date. For example, if the parent action is due on June 30, 2027, users should not be able…
