Count checkbox and text in a column
Hi, is it possible to count in a column, if I have check box and also N/A ?
I need to count every cell that has a check in the box or the N/A.
Thank you !
Comments
-
Try this - just change the column name for yours:
-
Thanks ! I will try it now
-
Not working...
-
Hmm. Can you share a screen shot of the column with the column name? It worked when I tested it. Sometimes copying/pasting a formula from here fails, better to type it out.
-
My formula was working before they decided to add the n/a....
I've tried your formula in both colums
-
Yes i've added a column for the formula
Ok l'll try it again.
Thank you so much !
D
-
Perfect!
-
I have a similar request, but I want to count any text in a row, not a specific word or phrase. For example, each row may have a different "comment" in a cell. Is there a way to make a formula that counts the checkbox, if checked, and also count if there is text in a cell.
Current formula is set up to count anything in that row, that is labeled "C" (for critical) when the checkbox is checked.
=IF(Critical@row = "C", COUNTIFS(Carleen75:Janet75, 1))
But when we have text in that row, it doesn't count it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!