The GSHEET Formula Updater is a Google Sheets add-on that enhances the readability of formulas by displaying them in a multi-line format with added comments. This helps users better understand and debug complex formulas.
- Formula Updater: Opens a dialog box where users can visualize and modify formulas.
- Retrieve Current Formula: Extracts the formula from the selected cell.
- Beautify Formula: Formats formulas by structuring them into a readable, multi-line format.
- Minify Formula: Condenses formulas by removing unnecessary spaces.
- Save Formula with Comments: Allows users to annotate their formulas with comments and store backups.
- Install the add-on from the Google Sheets extension marketplace.
- Upon installation, the add-on will integrate into the Google Sheets menu.(Extensions > Formula_Updater > Formula Updaetr
- Utilize the beautify or minify functions to reformat formulas.
- Add the updated formula (or Save version of your work with comments to track formula history => add your document id template inside 'save_formula.gs' code).
The add-on is built using Google Apps Script and operates directly within Google Sheets. It uses UI dialogs to enhance user interaction and allows efficient formula modification.
- Improved formula readability.
- Easier debugging and modification.
- Formula backup with annotation capabilities.
This add-on is open-source and free to use under the MIT License.
For Notepad++ users interested in updating google sheet formulas: visit the Google sheet Formula UDL (User Defined Language) for Notepad++