Alerts For When Nearing 5000 row Limit

Lisi · 06/24/19

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

Thanks!

Paul Newcome · 06/24/19

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å · 06/25/19

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 · 06/25/19

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å · 06/25/19

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 · 06/25/19

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å · 06/25/19

You're thinking of my TOC solution.

Alerts For When Nearing 5000 row Limit

Comments

Help Article Resources

Categories