Adding Checkbox
Hello!
I'm trying to figure out a formula that will allow me to add all the checked boxes in a column.
I have created a form asking about race, ethnicity, etc. and need to know the totals of each at the top of the column. I have searched around in the forums to try to figure what to do, but seem to be having a hard time.
Please help!
Laine
Answers
-
Hello @Laine Staton
It looks like you want to place the formula at the top of a checkbox type of column, is that correct? If so, we'll actually need to translate the number that you will find into a string, or into text (a checkbox type of column can either have text or checkboxes but can't house numerical data).
To do so, we can add + "" to the end of your formula and make the number into a string. The formula we'll use is a COUNTIF statement that COUNTs IF the box is = 1, or is checked.
Try this:
=COUNTIF(White:White, 1) + ""
You'll just need to swap out the column reference (White:White) to be the current column.
Keep in mind that since we converted it to text to display in your sheet, you will need to use a VALUE function to convert that number back into numerical data if you wanted to use it in other summary content (such as a SUM function or in a chart widget, etc).
As an alternative, if you have access to it, you could use the Sheet Summary section (see here) of your sheet to perform these calculations. You could then insert the COUNTIF function without the + "" into a Text/Number type of cell, which would keep it as numerical data.
Let me know if this makes sense or if you have any other questions!
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 381 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!