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

uwft

When troubleshooting issues with data limitations, I often need to check with a Smartsheet specialist about the number of cells used on a sheet. They will be able to refresh a view and find this to compare to my calculations of rows X columns and/or the little gray tooltips displaying in the bottom-right of a sheet when you select cells.

I believe it would save me and support time if I were able to see Smartsheet's calculations of my usage of cells and formulas. Through trial and error, I could determine whether and how to configure or divide my sheet.

Add this and any other metadata to the properties window for a sheet.

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

Kayla Q

I need this. I feel like I'm teetering on the edge of insanity trying to figure out if one more function is going to break my sheet.

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:

Quick Links

Trending ideas

Automations Tracker
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Preserve Original Filenames for Multi-Photo Uploads in Smartsheet Mobile App
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
Joyful Animations - in Smartsheet!
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.