Loading dashboard...
Dependency Mapper
Select a workspace from the sidebar to visualize asset dependencies
The graph shows how your sheets, reports, and dashboards are connected through cross-sheet references, report sources, and dashboard widgets.
3D Asset Visualizer
Select a workspace to visualize
Column-Level Dependencies
Select a workspace and sheet to view column dependencies
- Choose a workspace from the left panel
- Select a sheet to view its columns
- Click columns to visualize their dependencies
Pattern Recognition
Intelligent analysis of Smartsheet architectures, solution types, and complexity patterns
No Pattern Analysis Available
Run a scan first, then click "Analyze Patterns" to identify solution types, architectural patterns, and potential risks in your Smartsheet workspace.
10 Pillars Health Check
Proactive optimization recommendations for your Smartsheet architecture
-
Pillars Healthy
-
Need Attention
-
Total Issues
-
Health Score
Architecture Health Checklist
Scalability & Performance
Proactive Archival Strategies
Goal
Prevent performance degradation by identifying sheets approaching Smartsheet's row/cell limits before they cause issues.
Why Admins Care
Bloated sheets slow down loading, break automations, and can hit hard limits (500K cells, 20K rows). Proactive archival prevents outages.
Recommended Solution
Archive completed rows to a separate sheet, split by time period (quarterly/yearly), or use DataMesh to pull only active data.
Affected Resources
0 itemsAll Clear
No bloated sheets detected in your workspace.
High-Volume Reporting
DataMeshGoal
Ensure reports aggregating data from multiple sheets remain performant and don't hit source limits.
Why Admins Care
Reports pulling from many sheets can timeout, show stale data, or cause the underlying sheets to slow down for all users.
Recommended Solution
Consolidate source sheets, use DataMesh to pre-aggregate summary data, or limit report scope with filters.
Affected Resources
0 itemsAll Clear
No high-volume reporting issues detected.
Data Integrity & Architecture
DataMesh Candidates
DataMeshGoal
Replace brittle cross-sheet formulas (INDEX/MATCH, VLOOKUP) with automated DataMesh synchronization.
Why Admins Care
Cross-sheet formulas break when sources change, hit API limits, and don't scale. DataMesh is more reliable and performant.
Recommended Solution
Implement Smartsheet DataMesh to automatically sync data between sheets on a schedule.
Affected Resources
0 itemsAll Clear
No cross-sheet formula candidates detected.
Flatten Daisy Chains
DataMeshGoal
Simplify multi-hop data architectures where Sheet A feeds B feeds C feeds D.
Why Admins Care
Daisy chains create single points of failure, propagate errors, and make troubleshooting nearly impossible.
Recommended Solution
Pull data directly from source sheets using DataMesh, eliminating intermediate dependencies.
Affected Resources
0 itemsAll Clear
No dependency chain issues detected.
Error Hotspot Remediation
Goal
Identify and fix sheets with high formula error rates (#REF!, #INVALID, #NO MATCH).
Why Admins Care
Formula errors cascade, corrupt reports, and erode user trust. High error counts indicate architectural problems.
Recommended Solution
Audit broken references, rebuild corrupted formulas, and implement error handling (IFERROR).
Affected Resources
0 itemsAll Clear
No formula error hotspots detected.
Security & Governance
Dynamic View Candidates
Dynamic ViewGoal
Identify over-shared sheets that would benefit from role-based filtered views.
Why Admins Care
Sharing full sheets exposes sensitive data. Dynamic View lets users see only rows relevant to them.
Recommended Solution
Implement Smartsheet Dynamic View for role-based, filtered access to sensitive sheets.
Affected Resources
0 itemsAll Clear
No Dynamic View candidates detected.
External Sharing DLP Audit
Dynamic ViewGoal
Flag sheets with sensitive data (PII, financial) that are shared externally.
Why Admins Care
External sharing of sensitive data creates compliance risks (GDPR, HIPAA) and potential data breaches.
Recommended Solution
Security review, remove/mask sensitive columns, or use Dynamic View for external collaborators.
Affected Resources
0 itemsAll Clear
No external sharing DLP risks detected.
Stale Asset Cleanup
Goal
Identify orphaned sheets, unused dashboards, and abandoned assets consuming licenses.
Why Admins Care
Stale assets clutter workspaces, confuse users, and may contain outdated/incorrect information being referenced.
Recommended Solution
Archive or delete assets not modified in 90+ days after confirming no active dependencies.
Affected Resources
0 itemsAll Clear
No stale assets requiring cleanup.
Efficiency & Standardization
Form Candidates
Goal
Identify sheets with manual data entry that would benefit from structured form intake.
Why Admins Care
Manual entry leads to inconsistent data, typos, and missing required fields. Forms enforce data quality.
Recommended Solution
Implement Smartsheet Forms for data intake with validation, required fields, and conditional logic.
Affected Resources
0 itemsAll Clear
No form candidates detected.
Template Standardization
Control CenterGoal
Identify duplicate/similar structures that could be standardized with templates.
Why Admins Care
One-off sheets create inconsistency, make reporting difficult, and don't benefit from improvements to the "master" version.
Recommended Solution
Use Control Center for standardized project provisioning with blueprints and automated rollups.
Affected Resources
0 itemsAll Clear
No template standardization opportunities detected.
Run 10 Pillars Analysis
Analyze your scan results to identify optimization opportunities across all your workspaces
Risk Analysis
Pattern-based sensitive data detection across your Smartsheet environment
Total Findings
0
PII Detected
0
Financial Data
0
Secrets/Technical
0
Affected Assets
0
About Risk Analysis
What We Detect
SSN patterns, email addresses, credit card numbers, API keys, bank routing numbers, and more.
Review & Action
Click asset links to navigate directly to the data in Smartsheet for review and remediation.
Privacy First
We detect patterns, not actual data. Finding counts help identify risk without exposing sensitive info.
Loading admin dashboard...
Account Settings
Get help and access documentation
Plan: Trial
Full access to all features during your trial period
Quick Start Guide
1
Connect Your Smartsheet Account
Click "Connect Smartsheet Account" and authorize access to your workspaces.
2
Toggle Deep Scan for DLP Analysis
Enable Deep Scan to detect sensitive data like SSNs and credit card numbers in your sheets.
3
Start Your Scan
Click "Start Full Scan" to begin analyzing your workspaces. Free trials scan up to 1,000 assets.
4
View Your Results
Once complete, click "Open Zen Admin Dashboard" to view comprehensive reports on bloat, formulas, sharing, and more.
Security & Architecture
Zero Data Retention
We do NOT store your sheet content, formulas, or attachments. Data is processed in memory and discarded immediately after analysis.
Encrypted Token Handling
Your OAuth tokens are encrypted with AWS KMS (AES-256) at rest. Tokens are only decrypted in Lambda memory during active scans.
Ephemeral Processing
Stateless AWS Lambda functions wake up, process your data, and terminate. No persistent storage of your business data.
User-Owned Results
All analysis results are written to YOUR Smartsheet workspace. You own your data - we can't access your results without permission.
Architecture Overview
Your Browser
->
API Gateway (TLS 1.2+)
->
Lambda (Stateless)
->
Your Smartsheet
All data flows through encrypted channels. Your content never touches our databases.
Frequently Asked Questions
Can you see my sheet data?
No. Your sheet content is processed in Lambda memory only. It is never written to our databases, never logged, and is automatically discarded when processing completes.
What happens to my OAuth token?
Your OAuth token is encrypted with AWS KMS immediately upon receipt and stored as an encrypted binary blob. It is only decrypted in Lambda memory when needed for API calls.
Can your employees access my workspace?
No. Our employees do not have access to your Smartsheet account or workspace content. The OAuth token is encrypted and can only be decrypted by our Lambda functions during active scans.
Where are my analysis results stored?
In your own Smartsheet account. We create a "Zen Admin" workspace in YOUR Smartsheet, and all analysis results are written there. You own this data completely.
How do I revoke access?
Click "Disconnect Smartsheet" in our dashboard, or go to Smartsheet -> Account -> Apps & Integrations -> Revoke our app. Once revoked, we can no longer access your workspaces.
API Reference
Detailed documentation for Smartsheet API integration and advanced usage.
Troubleshooting
Common issues and their solutions to help you resolve problems quickly.
Change Password
Update your account password. You'll need to enter your current password for security.
Session Information
Logged in as:
-
Last login:
-
Contact Support
Submit a support ticket for personalized assistance with any issues or questions.
Video Tutorial
Watch our step-by-step video guide to learn how to use Zen Admin effectively.
FAQ
Find quick answers to common questions in our knowledge base.
System Status
Check real-time status of Smartsheet services and our API.
Error Analysis
Identify and resolve errors across your Smartsheet environment
Root Causes
0
Fix these to resolve all errors
Affected Cells
0
Total cells with errors
Critical
0
Column formula breaks
High
0
Cross-sheet / Circular
Medium
0
Pattern errors
Low
0
Isolated cell errors
Column Formula
0
Cross-Sheet Breaks
0
Circular References
0
Cascading Errors
0
Showing 0 entries
Sharing Manager
Search, view, and manage sharing across all your Smartsheet assets
How Sharing Manager Works
Instant Search
Search across all your assets instantly. Filter by workspace, type, or name.
Real-Time Sharing
Add or remove shares directly. Changes take effect immediately in Smartsheet.
Live Data
Current sharing status is fetched live from Smartsheet - always up to date.
Users & Groups
Share with individual users or organization groups. Set precise access levels.
Access Levels
- Viewer - Can view only, no editing
- Editor - Can edit content, cannot share with others
- Editor + Share - Can edit and share with others
- Admin - Full access including admin privileges
User License Analysis
Analyze user access patterns to optimize license allocation and identify savings
Loading user analysis...
DataMesh Audit
Scan and audit your Smartsheet DataMesh configurations
Loading DataMesh...
Workspace Analysis
Quality over quantity - understand which workspaces truly matter
0
Workspaces
0
Assets
0
High-Impact
0
Errors
0
DLP Finds
0%
Avg Health
| Workspace | Assets | Shared | Errors | DLP Risk | Health | Status | ||
|---|---|---|---|---|---|---|---|---|
|
Loading workspace intelligence... |
||||||||
Showing 0-0 of 0