Alerts For When Nearing 5000 row Limit

Lisi

Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit?

 

Thanks!

 

Paul Newcome

You would need to use a helper column to establish how many rows are currently on a sheet. You could then set up a notification to trigger when the number in that column reaches a certain amount.

Andrée Starå

Hi Lisi,

To add to Paul's suggestion.

The helper column could be an auto number column if you're not using one for anything else.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Andree,

 

I thought about the auto-number column, but then there's the hassle of having to reset it if you happen to delete any rows. 

Andrée Starå

Yes, of course! If that's the case!

Then it would be better to use a formula that would count only the actual rows.

Paul Newcome

I typically will reference a column that will always have text in it (task name for instance) and then use a straightforward COUNTIFS.

 

=COUNTIFS([Task Name]$1:[Task Name]@row, ISTEXT(@cell))

.

Of course you could always just reference the entire column and tuck the formula elsewhere and then trigger the notification off of that cell, but I use row numbers as a visual reference.

 

My particular uses involve actually displaying specific row numbers in some metrics (I believe it piggy-backs off of a solution you provided for something else) to give people the ability to quickly jump to past due tasks.

Andrée Starå

 

You're thinking of my TOC solution.