AppsScriptPulse

Add-on, Official News, Sheets

G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Tags:
| | 0 Comments |

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

Interesting to see Google extending the functionality of Google Sheets with this official add-on

Source: G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Add-on, Solutions, Forms, Sheets

Create a Branching Google Form – Teacher Tech

Tags:
| | 0 Comments |

Alice Keeler’s architecture on designing your Google Forms to provide immediate feedback by utilizing branching options is fascinating and efficient.

Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section with a tutorial or hint and a chance to answer a new question.

Source: Fast: Create a Branching Google Form – Teacher Tech

Add-on, Official News

How To: Add add-ons in Google Sheets – YouTube

Tags:
| | 0 Comments |

A short promo video from the official G Suite account showing users how to install add-ons in Google Sheets, which developers might find useful to reference or see how to structure their own add-on videos.

Add-on, Sheets

Custom Formulas Made by Top Contributors

Tags:
| | 1 Comment |

It’s been a while since we’ve posted updates on the Google Sheets Add-on “Formulas by Top Contributors”, but now the time has come around to make up for that !

Lots of other very useful utilities in this add-on which extends the formula/functions in Google Sheets including text matching with LEVENSHTEIN DISTANCE and JS_MAP & JS_SORT allowing you to include JavaScript syntax .sort() and .map()

Source: Made by Top Contributors