Workbook Statistics - Google Spreadsheet Add-on

Get stats for your current active sheet and the entire workbook in one place.

Finally! Its live on the G Suite Marketplace 🎉

Would love for some of you to critique it so I can improve 😅 will soon put out the code on GitHub and open-source this + also share a post on the entire process.https://t.co/5koer6xQt2 pic.twitter.com/goyRZFYEoJ

— Sourabh Choraria (@schoraria911) January 10, 2020

Post install tip:

• Refresh the sheet
• Navigate to the 'Add-ons > Workbook Statistics' menu
• Click on 'Get Stats' and wait until the add-on fetches the details
• Re-navigate to the 'Workbook Statistics' option and then hover over any of the 3 available options
• Hit 'Refresh All' to update stats

You can find stats for the following:

• Current Sheet:
  • Sheet Name
  • End of Sheet = Cell reference of where the sheet ends
  • Cells with Data
  • Named Ranges - similar to "Tables" in MS Excel
  • Pivot Tables
  • Cells with Formulas
  • Charts
• Entire Workbook:
  • Count of Sheets
  • Cells with Data
  • Named Ranges
  • Pivot Tables
  • Cells with Formulas
  • Charts

You can always connect with me on Twitter to share any suggestions or feedback as well!