top of page
With great power, comes great sheets
The possibilities are limitless.
Former mortals speak
“I was really struggling with using formulas in Google Sheets, but this add-on has made things so much easier! I can just input what I want the formula to do and it does it for me-it's like having my own personal assistant!"
“This add-on has saved me so much time and frustration! I don't know what I would do without it.”
Tom Smithenson, Former Mortal
“I never thought I could be so productive with Google Sheets, but this add-on has changed everything! It's so easy to use and makes my work flow so much smoother.”
FOR EXAMPLE / EGUse FOR EXAMPLE or EG. in your commands to show Formula God an example of what you want.
CLEANAdding CLEAN to your command will remove spaces, indents and generally fix formatting issues
Describing DataIf your data is comma-separated in the cell, tell Formula God it is comma-seperated in your command.
TRIMAdding TRIM to your command will remove space, indents and fix general formatting issues.
IFYou can give formula god commands like any other IF statement: IF this, do that.
RETURNUse RETURN at the start of your command, followed by your prompt.
CALCULATERun calculations on a range of data. Input: "[sum/average/count] the values."
-HAdd -H to the start of your command to ignore headers. Warning: this will remove Formula God's ability to gain context from your data.
APPENDAdding APPEND to your command will insert a value into the cell. E.g. append column A with ‘hello’, this will add hello to each item in column A
TRANSFORMTransform or extract values or strings in range. Input: "Extract the [x] from the [y]" "Transform to lowercase" "Replace [x] with [y] in the [string/value/type]" "Split the [x] by [y]"
QUERYQuery ranges and return the data you want. Input: "return the range where column [x] = [y]" "return the range where column [x] = [y] and sort by column [x] alphabetically" "return the range but return column [x] by [transforming it in some way]"
bottom of page