Sheet defaults to 50 rows
I have a sheet with 17 rows of data. Smartsheet automatically adds additional blank rows to equal 50 rows total.
I'm attempting to count UNchecked checkboxes in the sheet, but I'm unable to get a valid number. In other sheets with more rows of data, I'm able to subtract 10 from the formula (since 10 is the standard auto-generated number of blank rows). But it seems that if you have less than 40 populated rows, it will add extras to equal 50.
I'm experiencing this with multiple sheets.
How can I count unchecked boxes in this scenario?
Answers
-
Hi @Sldollman ,
Change your formula to a COUNTIFS and add a criteria that looks for an entry in another column in completed rows. Blank rows won't have data in the other field and won't be counted.
Need more help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks, Mark. This will work.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!