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!

Alerts for sheets with web forms

Noemi Kecskes

Hi everyone

I was wondering if there is a way to set up an alert when a sheet is approaching the limit of entries.

( data is coming in thorough web forms)

Thanks!

Noemi

Find more posts tagged with

Forms

Services

Email Notifications

Comments

Andrée Starå

Hi Noemi,

Yes, you could add an auto numbering column and have an alert triggered when it reaches a specified number.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

L_123

That won't work a second time though, as after she deletes the rows it will continue to count up from where it left off. It would be better to set aside a cell for the math

=if(countif(A:A,isblank(@cell)) + count(A:A)>4900,1,0)

That gives you 100 submissions before it maxes so you can go in and work on it without the chance of losing data. Just set an alert on the cell for when it changes to 1.

Andrée Starå

You're correct!

Depending on the need your method might be better, but with the autonumber column, the count could be reset if needed.

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Run Generate Document Workflow On Multiple Rows
Hello everyone, I have several rows (different entries) that I would like to enter on a custom form using the "Generate Document" workflow. I did a test run and it just generated "individual" PDF form per row - and not multiple rows merged into one form as I was expected. Is there another way or methodology around this or…
Sharing a Single Smartsheet with External Partners (No SSO Access)
Hi Smartsheet Community, I’m hoping you can help clarify a Smartsheet sharing question. I’m trying to share one specific sheet from my Smartsheet plan with two external colleagues from our partner organization. Several colleagues have mentioned they’ve successfully shared sheets with external partners before, so I’m hoping…
Form Creation
Is it possible to create a form on sheet 1 with information from sheet 2? On Sheet 1, I'm tracking what we ship and receive. On Sheet 2, I'm tracking the shipping requirements. I want to pull data from this sheet for a shipping request form on sheet 1.