In this tutorial I go from raw data to a full formed dashboard. In this particular case we're looking at the number of weeks someone might have left to live. A bit of stoic motivation, part baroque style. You'll see how I look for inspiration in the Memento Mori medallion and also in images representative of "Memento Mori" then I use those colors in the images to make this dashboard. In addition to that we build an hour glass for the number of weeks we've lived and have left to live. This Hourglass of Life might be something you can incorporate into other kinds of dashboards. Don't be afraid to build visual representations of your data to easily see what's going on.
Learn how to protect your Google Sheets while still collaborating effectively! Discover the three levels of protection and editability, as well as how to set permissions for specific ranges and cells. With Google Sheets, you can have the best of both worlds: a protected and collaborative sheet.
Ali gave away a free Google Sheet Template. In this tutorial I step through making it better, with better fonts, and colors. As well as making it more branded to share Ali's brand message better as the sheet gets copied and used, and shared. Great tutorial for those wondering how to brand your own sheets. Make your own lead magnets, and share your brand's message via Google Sheets.
SPOILER ALERT! In this video are the full solutions to the For Loop problems you can solve. If you haven't tried yet, copy the sheet and make an attempt to debug all 9 For Loops.
Learn how to debug a For Loop. These are common errors that happen when coding in Apps Script, specifically around the For Loop. This is Part 1 and 2. Get the goal of capture the flag exercise and I give you hints to each one.
Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.
The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.
Using People Chips and Date Chips to make a quick network building list even faster. Great to integrate Sheets with Gmail like this. Makes building the list and doing follow up so much faster.
Showing off New experiences in smart canvas changes to sheets. Including Date Chips, and Files Chips. Introduced in early 2023.
welcome to the technical walkthrough of VisiCalc 2023. This is the sheet that I released on April 1st for April Fool's Day. Learn how to use the onEdit() function in Apps Script. We learn the Apps Script for: Save a Sheet , Active Cell coloring, and the Out of Memory Toast.
Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.
Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the choices made for this template and "product". I chose specific fonts and colors based on the original VisiCalc.
This is a fun template I created for April 1st. Take a quick walk through the features here. And get yourself a copy of the sheet below.
We'll create a stop watch from scratch. Including Apps Script. What it will do is when you click a button (a checkbox) in a sheet, the script on every edit will add a start or a stop time, then add another time and calculate the duration.
Access the OpenAI API, walkthrough of the way we engineer the Apps Script so that we can play around with temperature and token length. Walk through UrlFectchApp as well and parsing JSON.