Sign in to join the conversation:
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
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
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.
You're correct!
Depending on the need your method might be better, but with the autonumber column, the count could be reset if needed.
Andrée
Good morning, Has anyone experienced issues with the Workspace files (the quick view panel on the left of the screen) disappearing? This just started for me today, and I'm not sure what caused it. I haven't been able to resolve the issue so far. Any ideas or suggestions would be appreciated. Kathy Snoke
We have 8 team members, all with member level permission. 7 of our users are fine, but we have 1 odd one out that is not appearing in our User Roles and Reports. When we tag him, only his email appears in our sheet. I can't figure out what's going on.
I have an excel that contains values that are hyperlinks constructed with Hyperlink construct. for eg: =HYPERLINK("https://docs.oracle.com/en/cloud/saas/readiness/common/26b/common26b/26B-common-wn-f43843.htm","Multifactor Authentication (MFA)") When I import that into smartsheet, all the values read #UNPARSEABLE. I see…
