Get stats for your current active sheet and the entire workbook in one place.
Finally! Its live on the G Suite Marketplace 🎉
— Sourabh Choraria (@schoraria911) January 10, 2020
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
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!
Top comments (0)