Hey there stranger!

Sign up to get access.

Unique Features - Design a Better Dashboard Part 2

About this Tutorial

We're gonna talk about some features that we're gonna be using that might be new to you, or, just remind you that we're gonna use them to make 'em very interesting and unique to, using dashboards.

Video Transcript

 Hi, uh, welcome to part two. We're gonna talk about some features that we're gonna be using that might be new to you, or, um, just remind you that we're gonna use them to make 'em very interesting and unique to, uh, using dashboards. But just before that, I wanna review the notes. The reason we're using these features are to be able to lead the eye to that necessary information.

We're only gonna show necessary information in the way that we need to show it. We're also gonna keep a lot of data or math equations out of view, and we're also gonna show not just the data, not just the actual number where app, we're gonna show that comparison. Delta changes between, uh, month over month time periods, week to week.

Daily, we can do a lot of different comparisons, but we're gonna show the data plus that comparison. And these help us. So first I just wanna remind you that we can set our own colors. Uh, when you're creating a dashboard, even in Google Sheets, one of the simplest and sort of lazy and easiest things to do is to create just black and white information.

But if you set your own colors for your business, Hey, you can even screenshot that and, and share that in, uh, emails. Instead of having to share a Google sheet, you can just share a really nice, uh, uh, version. Or you can even, um, if you have, uh, some interesting charts you can make in Google sheets, in your colors, and then share them on like LinkedIn publicly if you wanna share certain, uh, information.

But also it makes it, uh, feel better and closer to your branding if you have even a small company, 3, 4, 5 people, or even up to 10 people. Um, as long as you're working within your own colors and you see these colors all the time, it makes you feel like you're part of, you know, a team. Um, we're gonna use conditional formatting.

Uh, this is really good for, uh, sort of creating heat maps and creating, um, types of, um, comparison without having, uh,  in addition to seeing the numbers. Uh, so you see some liquidations of colors, but you can also, um, create some interesting things with conditional formatting. Um, and you might have seen my other, uh, video.

I do a lot of more interesting creative use of conditional formatting. There all, there's like a whole video all about conditional formatting. Uh, this gauge chart is a rather interesting chart. You can set the colors on it, you can set its minimum maximum, and. This, just like I was talking about in the last video, is speedometer where you can use this to see if an some piece of information or some data is within a good range.

Or if it's like too much or too little, um, and you can use this, uh, literally in your dashboard. Um, I'm also gonna share with you these characters. This is an up and down Chevron, I think, and I think they're actually like other, I think they actually have a real name, like a, it's probably some kind of accent, but we're gonna use it as an up chevron and a down Chevron to show up and down.

We can actually, uh, even color these right now. This isn't a fun of Forta, but we can change this to. Be any style and why I share the character number is because the way we get it is literally doing this formula equals C H A R for character, uh, and then 7 0 8 for up and 7, 0 9 for down. This is going to help us showcase.

um, that those deltas, right? If we see something going up or down, we're gonna a, see the number is up, uh, a positive. We may see a number that's negative, or we may just see two numbers and we don't know if it's going up or down based on. Our temporal or like time, right? Week, week, week over week or month over month.

Um, this helps us literally see, oh, we're on Upward Slope. We'll also create some little charts, um, some spark lines maybe. Um, I have a whole, um, video series on a progress bar. We're probably gonna skip that because that's in the other video. But we might, um, we may jump into some other things when we build a dashboard.

So these are all the features we're gonna. Uh, go through it and, uh, I'll see you in the next video to actually build the dashboard.

Courses

Sheet Stories / Video Notes + ADDED: Email Notifications

00:00:00

Fast FAQS

ChatGPT Clone in Google Sheets Part 2

Create an Internal Google Sheets Add-on

Why Different Cell References in AI Integration in Sheets?

Show Sheet Tabs Based on Edit

Add Title Case to Google Sheets

Getting Started Coding in Apps Script

How to Power Testimonials with Google Forms and Sheets

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 1

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

00:29:08

Hold a Giveaway Raffle in a Google Sheet

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a Headline in a Website from Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Create a new Spreadsheet from just a Name in a Sheet.

00:05:21

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

00:05:43

Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets

Create an Email Campaign Stats Calculator

00:35:13

Twitter App Clone in a Google Sheet

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet

00:11:22

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

00:12:29

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Sync Two Tabs Without ImportRange()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

00:00:00

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case

00:07:35

Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode

00:05:10

Write Your First Script

00:08:31

Find Keywords in Any Column. Create quick search dropdown to find keywords

00:09:37

Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator

00:11:20

Let's Make a Bookmarklet!

00:12:37

Troubleshooting Bitly in a Google Sheet Script

00:07:07

Unique Features - Design a Better Dashboard Part 2

00:04:13

How To Set Up Stripe Webhook to Google Sheets with Google Script

00:22:10

How to Edit a Macro

00:08:22

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

00:35:10

Add A Timestamp to Task Lists (without Now Formula)

00:07:44

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

00:17:58

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

00:23:26

New Syntax for WhatChanged Formula in Google Script

00:07:14

How to Record Macros

00:06:20

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

00:09:53

Deep Inside Dark Habits Google Script

00:18:54

How to Trigger Macros Daily

00:06:58

5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Apps Script

00:15:01