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

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭✭
    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

  • Garrett Henke
    Garrett Henke ✭✭✭✭✭✭
    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.

  • That did it - Thanks for such a quick resolution @Garrett Henke! 😃