Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard

AdrienneBarton

There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results.

Any help or advice anyone has is welcome.

Thank you!

Andrée Starå

Hi Adrienne,

Unfortunately, there isn't a way to don't have those 10 blank rows in the bottom.

How is it affecting your dashboard? What formulas are you using?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Brian Lynch

Hi Andrée,

This is affecting me now as well. My formulas look for "" in an "Assigned to" column, so we know how many projects are currently unassigned. Any way to address this? The issue is inflating the number on our dashboard.

Thank you

Andrée Starå

Hi Brian,

Depending on the structure of your sheet you could subtract in the formula by the same amount.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Hi Brian,

Did you get it working or do you still need help?

Have a fantastic week!

Shile

I have the same issue, is there a workaround?