--- Introduce Yourself
--- Answer the Question of the Month
--- Connect with your Peers
Critical sheet status
Hello everyone. I have another personal best practice to share. I am sure like many of you there is a method to the madness. You have some absolutely critical sheets and if not kept within limits could crash it all. So In order to keep eyes on my critical sheets I created a Sheet status page for me to monitor all those critical sheets in one place.
I added cell counts, Call ins and call out counts to each of the critical sheets. I then cell link the data to this sheet and allow the conditional formatting do its magic. Automations will also send me an alert when a sheet goes above 50% of either call in max or 50% of total cell max. The important key for this sheet to work is a Strong management of change process for these critical sheets to ensure no other admins are adding columns or calls without awareness. Sheets can get out of hand quickly if not regulated when multiple people have admin rights to sheets or workspaces.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
Comments
-
Great idea!
By Call In/Call Out are you referring to inbound/outbound cell links/references?
Are you able to count links with a formula or where are you getting that number from - manually from the reference manager?
Thank you!
-
Thanks! @ker9 Yes I am referring to inbound and outbound cell links/references. Its very important to track those inbounds. I take a row count and multiply it by the manual column counts of inboard/outboard columns. There currently isn't a formula for these counts but the idea has been submitted by several Community members.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
-
@Ken Armstrong - thank you for the clarification. I was hoping you had found a magic formula. :)
I do something similar on individual sheets with warning notifications. I like the idea of a status sheet.
-
@ker9 Oh I wish they would roll this magic formula out already. It is very helpful to see all my critical sheets in one place.
Ken Armstrong
Smartsheet Project Manager, GE Aerospace
Certified Smartsheet Administrator
Be Firm! Be Fair! Be Friendly! Be Honest!!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives