What is Formula Studio
And how can help you to build faster
At the end of December, my brother and I launched the first version of our add-on on Google marketplace: Formula Studio.
What is it?
It is the first code editor for Google sheets formulas. This means that we can stop using the text box or the cell to create formulas and we can replace it with a professional code editor.
Why Formula Studio?
The main problem that the tool solves is the visualization and editing of formulas. Let’s imagine that we enter a company and in one of the Google sheets we find that this formula is broken:
How do we fix it? We would have to test each part only to understand what the formula does. Wouldn’t it be much better to see it like this?
Does it have other features or is it just for better visualization of the formulas?
Of course, it does! But first, it’s worth clarifying: With Formula Studio you can get formulas from any cell, edit and save them, as well as create new ones from scratch.
Other features that may interest you:
- Replace all
Many times we find that we have to modify something that appears multiple times in a formula, instead of changing one by one, we can do this:
2. Named ranges
A great practice when working with Google sheets is to name ranges to use in our formula, that way we know what we mean by each range. In FS we can name ranges from the editor and replace them in the formula automatically.
3. Shortcuts
Although it already exists, by tapping CTRL (Command on mac)+ SHIFT + ENTER you can add ARRAYFORMULA()
The novelty is to add IFERROR() with CNTRL(Command on mac) + SHIFT + SPACE
4. Paste the formula in multiple cells
Once you have edited/created your formula, you can paste it into a range.
All one column below
Specific range
You can also run the formula and paste the values, so you don’t have hundreds of calculations and keep the spreadsheet light.
5. Format document
An important thing when we are editing or creating is to be able to format on the fly to see the formula better.
6. Dark mode
Less important but I think it is very cool to have Darkmode in the editor to create formulas!
Conclusion
FS allows us to create and edit complex formulas in a much faster way than usual and therefore increase our productivity in Google sheets.
I leave the link for you to download >>> Formula Studio
