Sign in to submit new ideas and vote
Get Started

Sheet Statistics

ker9
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.

25
25 votes

On Wishlist · Last Updated

Thank you for posting this idea - sheet statistics is a feature we’re considering for the new table view which will first be released as part of the Early Adopter’s Program. Please keep adding your suggestions to the thread below!

Comments

  • Cleversheet
    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
    ker9 ✭✭✭✭✭✭

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

    Pivot, DataMesh, DynamicView, WorkApp, etc.

  • Ken Armstrong
    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.

    Ken Armstrong

    Smartsheet Project Manager, GE Aerospace

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

  • Diane Moore
    Diane Moore ✭✭✭✭
    edited 05/09/23

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

    # of rows

    # of columns

    # of cross sheet references

  • Samuel Mueller
    Samuel Mueller Overachievers

    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
    Samuel Mueller Overachievers
    edited 02/09/24

    @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
    Kyle Chipman Overachievers
    edited 02/09/24

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

  • Kyle Chipman
    Kyle Chipman Overachievers

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

  • 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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

  • Samuel Mueller
    Samuel Mueller Overachievers

    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
    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.
    A.J. ✭✭✭✭✭✭

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

  • Eric B.
    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: