Request - add # cells referenced to the right tool bar

John Pammant

Add a count for the number of cells reference in the sheet to the Activty Log and "Manage Reference" panel.

I am constantly hitting the 100,000 cells or 25,000,000 cells reached.

I want to get a heads up before my sheet crashes.

If there is a count, I can see if my changes are working or not.

The count should show which cell or column has the most references.

Also, make the columns adjustable, and add a scroll bar to the "Manage Reference" panel.

Thanks

Cameron Nelson

Smartsheets lose the ability to be edited/saved when they hit a certain number of cross-sheet references (250,000 by default) on a given sheet. This is not hard to do on the central management sheet of a system.

As currently there is no way to see what a given sheet is up to, this loss of functionality can seemingly come out of nowhere too.

As such, I propose the ability to see a total count of cell references on the Manage References panel, as well as some kind of early warning (Perhaps an email to the owner, though preferably something more persistent as a reminder) to alert that a sheet is approaching that limit.

Ideally, that alert would be dynamic to the number of references a given row would add, so you could know when you are, say, 20 rows or less from the limit. (Rather than just a certain number of cell references themselves)

SSFeatures

Hi @John Pammant and @Cameron Nelson,

I added a feature into SSFeatures that should be able to help here.

With SSFeatures, click this "View Sheet Stats" button:

And then you'll see a popup like this that shows you stats about your sheets, so you can see how close you are to the limits.

Hope this helps!