Formula Editor

Interface Overview

1. Additional tabs can be created using the “+” symbol to the right of the open tabs.
   Tab sub-name (in gray below the bold tab name) is auto-set whenever “Insert” is used, so that users know the most recent place that tabs code was pushed into the Sheet
   • Addition tab controls are used by clicking the downward pointing carrot symbol within the tab:
     
     • Rename (selected tab)
     • Duplicate (selected tab)
     • Close (selected tab)
     • Close others (close all tabs except selected tab)
     • Close to left (close all tabs to the left of selected tab)
     • Close to right (close all tabs to the right of selected tab)
       
2. Basic Editor Tools, Section 1
   • Undo
   • Redo
   • Find (text within current tab)
   • Paste
3. Basic Editor Tools, Section 2
   • Increase text size
   • Decrease text size
4. Editor View Options
   • Hide / Show number delineated rows
   • Hide / Show minimap of code in editor
   • Hide / Show bullet indication of spaces between text
5. Excel Syntax Support dropdown
   • Activate excel syntax support by selecting “Microsoft Excel” in dropdown
   • Deactivate excel syntax support by selecting “Google Sheets” in dropdown
   • “?” Click to see supported formulas by feature auto translation
6. Open AI Assistant feature
7. Open Variables feature
8. Open Snippets feature
9. Minimap of code in selected tab
10. Selected row in Editor
11. Preview of code in Editor (what would be pushed into a cell when using the “Insert” button)
12. Copy code in Editor
13. Save code in Editor as a Snippet
14. Pull the contents of the currently selected cell in the Sheet into the Editor
15. Currently selected cell in Sheet
    • Displays the name of the cell currently synced with the Editor
    • Sync (refresh icon) button updates which cell is currently selected in the sheet
16. Insert Editor code (of the currently viewed tab) into the currently synced cell in the sheet