Best Of

Hi @Georgie,

I figured out why this bug is happening, while developing some new features for SSFeatures.

The problem happens if the user clicks the page when the "loading…" or "saving your data…" popup is open. If you click when this little popup is open, then the entire page breaks, and it's impossible to click your cells, or click many of the other buttons on the page.

I can reproduce this 100% of the time, here's what I do.

1. Change some data in a cell.
2. Click File > Save (or press CTRL + S)
3. Immediately start spam clicking the left mouse button.
4. Saving the data will cause the popup to appear, and then clicking will cause the page to break.
5. You will not be able to click into any cells, until you fully refresh the page.

Here is a video of me replicating the problem:

I figured out in Smartsheet's JavaScript code why this problem is happening.

The problem is in the FormObjectHandler's handleMouseDown function. If you click when the progressIndicator is busy, it sets the isCancelled_mouseDown_ignoreClick variable to true, and there's nowhere in the code where this variable gets set back to false. So the application will continue to ignore all of the clicks until the user refreshes the page.

Here is the code snippet:

e.prototype.handleMouseDown = function(e, t) {
  if (!this.areAllEventsDisabled())
    if (this.progressIndicator.isBusy)
      this.isCancelled_mouseDown_ignoreClick = true;

I hope this helps the Smartsheet team understand and fix the problem!

Because forms are explicitly meant to collect new info, you can't use a form to UPDATE existing information. HOWEVER, you can collect information and use it to update info. Depends on how you want to deal with your data.

Option 1: Create the form that you did, but just use it with a sheet that is devoted to nothing but staging your data. If "New" is chosen, create an automation when the form submission is received (or on whatever cadence you decide) to move the row to your sheet that contains employee info. If "Existing" is chosen, use something like an Employee ID number or some unique identifier, in combination with Data Mesh to update the fields on your employee info sheet.

Option 2: Create your form BUT JUST FOR NEW EMPLOYEES. For EXISTING employees, use a tool like a Report (and sharing to the underlying sheet), a WorkApp (with a report to that underlying sheet), or Dynamic View to give people access to edit info on the underlying sheet.

Between the two, I recommend Option 2 - if you don't have any premium apps, you can do it - and you have one less sheet to deal with.

Good luck!

• Trigger: When a form is submitted AND user = "Current"

• Condition: Match email/ID with existing row

• Action: Send Update Request to the person who owns that record (or to HR/admin)

• That update request will allow them to edit the existing row instead of creating a duplicate.

First: The rows will be copied to the first UNUSED row in the new sheet. Even if a row is blank, if it previously had data in it before, it is considered used and will be skipped. Make sure to delete the rows themselves and not just the data from the cells in the row.

Second: Try converting the formula to a column formula.

Thanks for sharing your experience. We were able to delay moving to USM until June 2026 and, hopefully, by then some of these kinks will be worked out. We have talked to Smartsheet about making the true up process more automated. Like, why not use a Smartsheet for the true up list and then have automations go out to the impacted users and ask them whether or not they want a paid license, want to downgrade to viewer or remove their account from our plan but Smartsheet insists on giving us a list of people in a UI and making our System Admins do all of the leg work. As it is, it is completely unreasonable and very poorly designed. We don't use Okta so we don't have a way of automating it from that end. We expect to take some steps to prepare for this eventuality during the upcoming year and to continue the process of evaluating alternate products in case the decision is made to exit from Smartsheet. It's only prudent to be prepared if the costs get out-of-control.

Hi @David Jensen, since this feature request has been requested a lot, I built a browser extension (SSFeatures) to add this feature into Smartsheet.

With SSFeatures, open the "Sort Rows" menu and then click on this "Sort Automatically" button. Then your data will automatically sort whenever it changes.

@kowal in the past, no. I will put in another ticket and see if anything has changed.