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.

Sign in to vote!

Find more posts tagged with

Sheets

On Wishlist

Enhancement Request

Comments

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:

SSFeatures

Based on the feedback in this thread, I added this feature into SSFeatures.

With SSFeatures, click this button:

And then you'll see all of your sheet stats:

Hope this helps!

Samuel Mueller

Very cool feature @SSFeatures. Thank you for bringing this much needed feature to smartsheet.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.