Sheet Statistics

ker9

Something that quickly shows

# of rows

# of columns

# of cells

# of cross references

# of unique formulas

I'm sure there are other metrics that would be nice to see quickly

Close to breaking warning or notification to sheet owner

Could be part of Work Insights but all together, like a table, and update immediately.

Cleversheet

YES! And have it appear, along with other useful Sheet info (especially a [copyable] list of all Column names, with Show/Hide checkboxes) when clicking the completely wasted but potentially highly useful empty block at the upper left nexus of row and column.

ker9

Include ability to see what APIs are attached and who the owner of the API is.

Pivot, DataMesh, DynamicView, WorkApp, etc.

Ken Armstrong

So I maintain a couple critical sheets and ensure they stay within limitations. I have my own way of keeping cell counts and call in counts, but it would be fantastic it it was a real simple count that is displayed live on the sheets already.

Diane Moore

This is very much needed. To be more specific, this could include:

# of rows

# of columns

# of cross sheet references

Samuel Mueller

Sometimes when a sheet is getting close to it's max, I start getting nervous without knowing how many rows can be added before everything breaks. We have a lot of control center program toolkits with sheets that contain a lot of columns, and a lot of rows. Please provide an easy way to identify when a sheet is reaching it's max so we can take the necessary precautions.

I see this in File -> Properties, then show a Column Count, a Row Count, Cell Count, and a % of sheet usage.

So if there are 100 Columns, 4000 rows, that would be 400,000 cells, and 80% sheet usage. Then I can determine when I need to start archiving rows.

Samuel Mueller

@Genevieve P. I'm so sorry I did it again. Can you please add this to this post that was already out there 😅

Sheet Statistics — Smartsheet Community

I'll try to be better

Kyle Chipman

I’ll upvote other post, but the ease of this visibility is totally warranted and super helpful. Great enhancement request.

Kyle Chipman

Echoing all the responses - totally warranted and useful in an everyday capacity. Excellent enhancement request.

Genevieve P.

Haha no problem at all @Samuel Mueller - merged! Thanks all for providing your votes and feedback, it's always useful to have more information around why an Idea is important to you.

Cheers,

Genevieve

Samuel Mueller

This may be captured, but I just ran into this again. Another helpful sheet statistic would be the number of cells referenced in formulas. Need to know how close I am to the 25,000,000 max references.

Nik Fuentes

I'm told that the existing feature request to have columns hidable/unhidable from a list has also been folded into this request.

Better unhiding, specifically, is a very important thing Smartsheet can do better and might well belong here.

A.J.

Sheet stats seems simple but it would be so very helpful!

Eric B.

I just ran out of cells in a sheet and needed to fire fight to recover some data that pours in via an automation. Generally I don't need to create a new sheet until year end each year, but this year saw an uptick in line items.

Is there a way to collect high level property information from a sheet?I was envisioning something like this that could contain populated cell count, unpopulated cell count, number of columns, file location, file size, relevant date information…. etc.

ie. Right Mouse button on a file, Properties: