We have built a SS to take registrations for Covid vaccinations. We are anticipating over 40,000 people to register. Will my sheet be able to handle that many rows?
No, not without an archive sheet because the limit is 20 000 rows.
You could move rows to the archive automatically.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
My team have a lot of experience doing this with the NHS in the UK. We are taking actual bookings rather than Requests for an appointment which is far less maintenance but if you are happy with Requests then I suggest you create a reasonably sophisticated workflow like the Smartsheet Free template for requests, which will help a lot. There is a danger of overbookings ( two for the same slot at the same time) . I definitely would not run that number through one form, one sheet, you need to break it up. The pinch point will come when you release the Form link, so stagger them.
If you want a ready made Booking system we have exactly that in Smartsheet but using a web form connected via our server to Smartsheet, so on choosing a date, if its full it will say so, or offer you any remaining slots along with a second jab booking according to your local "Jab Gap" rules. ie 30 days?
We have addressed the issue of volume and security which we can discuss privately if you wish.
Hope that helps
The number of Unlicensed Users was listed previously under User Accounts. Why is it no longer there?
I have a filter set so that if this task complete box is checked, then the row is hidden. Is there a way to make it so that if the parent row is checked, then the child rows hide as well? Right now when a parent row is checked, only the parent row is hidden.
Does anyone know why Editor cannot insert columns in a sheet? What's the harm in that? I can see why you might not want someone to delete or rename a column, but inserting a column seems harmless.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.