COUNTIF Empty returns 10 extra lines
New to Smartsheet - Built a primary sheet, populated by form. 👍️
Now building a Metrics sheet to gather Status row counts to build a Database w/metric widgets.
For some reason 10 extra rows are being added to my primary sheet when I use the COUNTIF formula on the Metrics sheet that references the Status column in my primary sheet. 😟
I have deleted these 10 rows several times - same results when I come back after building the formula on the Metric sheet w/the referenced primary sheet column. Each empty row has the notation that it's used on the Metrics sheet.
New rows are set to be added to the top, not the bottom of the sheet from the form.
Why when I select the reference of the primary sheet does it add the extra 10 rows?
Any help would be appreciated!
Best Answer
-
Sheets by default have 10 rows at the bottom. What you can do to navigate around the 10 extra rows is use a COUNTIFS() function for the Empty Requests metric.
=COUNTIFS({CPEX Status}, "", {CPEX Request Name}, "")
This way you are only counting requests that have not been assigned a status and not the blank rows.
Answers
-
Sheets by default have 10 rows at the bottom. What you can do to navigate around the 10 extra rows is use a COUNTIFS() function for the Empty Requests metric.
=COUNTIFS({CPEX Status}, "", {CPEX Request Name}, "")
This way you are only counting requests that have not been assigned a status and not the blank rows.
-
That did it - Thanks for such a quick resolution @Garrett Henke! 😃
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives