I will fix google sheets formulas and apps script errors
Python AI Regex and AppSheet Data Engineer
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
About this Gig
I will fix Google Sheets formulas and Apps Script that return the wrong result, throw an error, or run too slowly.
You receive:
- A corrected formula, including ARRAYFORMULA, QUERY, FILTER, VLOOKUP, XLOOKUP, INDEX and MATCH
- An Apps Script fix when the bug is in the script
- A short note on why it broke
- One revision on the same file
Share the sheet, mark the cells that fail, and paste the error or a screenshot. Tell me the result you expected.
Most formula fixes are ready within 1 day. A script with several functions takes 2 to 3 days.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Formulas
•
Macros
•
Cleaning
•
Data validation
My Portfolio
FAQ
What kind of formulas or functions do you specialize in?
I specialize in advanced, complex functions like QUERY, ARRAYFORMULA, INDEX/MATCH, and FILTER. I focus on creating scalable formulas that automatically update and are efficient for large datasets in both Sheets and Excel.
Can you help me fix a broken formula or script?
Yes, absolutely. My Basic and Standard packages include troubleshooting. I can quickly debug existing formulas, fix logic errors, and optimize complex sheets for better performance and reliability.
"Macro" the same as "Google Apps Script"?
Yes. A Macro in Excel is generally a Google Apps Script in Google Sheets. I write custom JavaScript code to create powerful automations like sending emails, generating reports, and integrating data.
Do you need access to my entire Google Sheet?
I need temporary access to the specific sheet to implement and test the formulas/scripts. You can grant me Editor access or send me a copy of the sheet without sensitive personal data. I will always handle your data securely.
Can you help me automate a task using a button?
Yes. The Standard and Premium packages include setting up buttons or custom menu items (Toolbar Integration) that run the Google Apps Script automation with a single click, making your workflow extremely simple.
