Formula Genius

Compare two formulas and recommend which one is better. Evaluates formulas based on accuracy, performance, and readability. Use when the user has multiple ways to achieve the same result and wants to choose the best approach. Respond with a short confirmation only; full details render in the widget.

Create a private link for the current user's formula card. Widget-accessible only.

Find and fix errors in a spreadsheet formula. Use when the user has a formula that returns an error like #REF!, #VALUE!, #NAME?, #N/A, or isn't working as expected. Examples: - "Fix this VLOOKUP that returns #N/A" - "Why is my formula giving #VALUE! error?" - "This SUMIF returns wrong results" - "My formula worked but now shows #REF!" Respond with a short confirmation only; full details render in the widget.

Break down and explain an existing spreadsheet formula step by step. Use when the user pastes a formula and wants to understand what it does or how it works. Examples: - "What does this VLOOKUP formula do?" - "Explain =SUMIFS(B:B, A:A, ">10", C:C, "Complete")" - "Break down this INDEX MATCH formula" - "How does this array formula work?" Respond with a short confirmation only; full details render in the widget.

Generate Airtable automation scripts from natural language. Use when the user asks for Airtable automations or scripting. Respond with a short confirmation only; full details render in the widget.

Generate Google Apps Script for Google Sheets from natural language. Use whenever the user asks for Apps Script or Google Sheets automation. Respond with a short confirmation only; full details render in the widget.

Convert a natural language description into an Excel or Google Sheets formula. Use when the user wants to create a formula, calculate something in a spreadsheet, or needs help with spreadsheet functions like VLOOKUP, SUMIF, INDEX/MATCH, etc. Examples of requests this tool handles: - "Calculate commission on sales over $10K" - "Find duplicates between column A and column B" - "Count weekdays between two dates" - "Sum values where status is 'Complete'" - "Extract text after the last space in a cell" - "Calculate running total with conditions" - "VLOOKUP that returns multiple columns" Respond with a short confirmation only; full details render in the widget.

Generate VBA macros for Excel, Apps Scripts for Google Sheets, or Airtable automation scripts from natural language. Examples: - "Create a VBA macro that highlights cells above 100 in red" - "Apps Script to send email when cell value changes" - "Macro to auto-format dates in column A" - "Script to copy data between sheets daily" Use when the user needs automation scripts beyond simple formulas. Always call this tool for VBA macros or Apps Script requests. Respond with a short confirmation only; full details render in the widget.

Generate SQL queries for MySQL, PostgreSQL, SQL Server, or SQLite from natural language. Examples: - "Get all customers with orders over $100" - "Find duplicate emails in the users table" - "Calculate total sales by month" - "Join customers and orders, show top 10 by revenue" - "Update prices by 10% for products in category 'Electronics'" Use when the user needs database queries. Respond with a short confirmation only; full details render in the widget.

Generate Excel VBA macros from natural language. Use whenever the user asks for a VBA macro, Excel macro, or VBA script. Respond with a short confirmation only; full details render in the widget.