The 4 Pillars of Sheet Navi™
1. Sheet™ Navigation (The Control Panel)
Manage hundreds of tabs effortlessly through a single "Hub" grid.
- Sync & Rename: Physically reorder tabs by changing "Order #" or bulk-rename multiple sheets™ at once.
- Visibility & Protection: Toggle "Show/Hide" status or apply "Warning-only" protection across your entire workbook in seconds.
- Audit & Clone: Run sheet audits to find formula density or clone specific sheets with custom names.
2. MultiLookup Function (The 2D Engine)
Eliminate the need for complex VLOOKUP or XLOOKUP combinations with a smarter 2D engine.
- Smart Intersections: Automatically detects range orientation to find the exact point where row and column criteria meet.
- Native Conversion: Converts input into native Google Sheets™ formulas so the sheet™ stays fast for all users.
- Range Snapping: Automatically "snaps" search ranges to match the height or width of your data.
3. AutoSort (The Infinite Watcher)
Keep your data in order continuously without manual sorting; just set your sequence and let the engine work.
- Two-Level Sorting: Supports primary and secondary column sorting (e.g., Sort by Date, then Name) in A-Z or Z-A order.
-Trigger Rules: Set "Required Columns" that must be filled before the engine automatically sorts the table.
- Real-Time Organization: New values are automatically snapped into the correct place the moment data entry is finished.
4. Multi-Level Dropdowns (Dependent Logic)
Create professional dependent dropdown chains where options change instantly based on your previous selection.
- Chain Selection: Perfect for "Category > Sub-Category" flows, ensuring users only see relevant options.
-Data Integrity: Downstream dropdowns automatically clear and display a warning (⚠️ Select...) if a "parent" choice is changed.
- Automated Setup: Sheet Navi removes duplicates and sorts your source table alphabetically for you.