nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

What happens when I reach my 5000th row?

Vivien Chong

May I know if there will be any alert when a sheet is reaching it's 5000th row?

My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity?

Thanks.

Find more posts tagged with

Human Resources

Manufacturing

Sheets

Comments

Andrée Starå

Hi Vivien,

Yes, you'll get an error message when you've exceeded the size, but not when you're reaching it if I remember correctly. (see attached screenshot)

A workflow could be set up with so-called helper column(s) that would send alerts, move/copy rows.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Sheet size error.png

Vivien Chong

Thanks Andree.

On the alert notification, how to do that to receive notification nearing the limit?

We can't move row as the sheet contains vlookup formula and we need it for database record.

Will the vlookup formula be in error if we move the row to another sheet? (have not tested this yet)

Thanks.

Andrée Starå

Happy to help!

If you don't delete or move rows, we could use an auto number column and then set up an alert or similar to trigger at a specific number.

The VLOOKUP would probably not be in error, but I'd need more information to be sure.

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…