- Видео 144
- Просмотров 134 555
Spreadsheetables
США
Добавлен 27 янв 2023
What To Do When You Can't Simply Copy The Table from ChatGPT into Google Sheets
What To Do When You Can't Simply Copy The Table from ChatGPT into Google Sheets
Просмотров: 65
Видео
Calculate Multiple Service Prices using Google Sheets' Multiple Selection Dropdown - NEW UPDATE!
Просмотров 13714 дней назад
In this video, I'll show you an effective way to calculate the total price of multiple selected services in Google Sheets, after the recent multiple selection dropdown menu update. I'll guide you through the steps of creating a separate tab to list all your services and their corresponding prices. Then, using the SPLIT, SUBSTITUTE, and SUMPRODUCT functions, we'll break down the selected service...
Time Formatting Made Simple in Google Sheets - Best Practices for US Users
Просмотров 5921 день назад
In this quick tutorial, I'll show you the best time format to use in a Google Sheets spreadsheet, especially if you're targeting a US audience. Learn how to set up the 12-hour format with AM/PM, and get tips on customizing the time format to suit your needs, whether you're working with a US or international audience. Watch this video to make sure your time formatting is spot on in Google Sheets...
How To Turn Off Irrelevant Keywords When Running Etsy Ads For Optimized Audience Targeting
Просмотров 166Месяц назад
This is a video about How To Turn Off Irrelevant Keywords When Running Etsy Ads For Optimized Audience Targeting 0:00 How To Turn Off Irrelevant Keywords When Running Etsy Ads For Optimized Audience Targeting
Creating Filters for Each Individual Category In Your Google Sheets Spreadsheet
Просмотров 296Месяц назад
This is a video about Creating Filters for Each Individual Category In Your Google Sheets Spreadsheet. One of our spreadsheet membership members, Beth, had a request, and we figured we'd share this super helpful tip with everyone else! 👍 Like, Comment, and Share if you find this video helpful! 🔔 Don’t forget to hit the notification bell to stay on top of all things digital creation and google s...
Connect Google Drive to ChatGPT
Просмотров 1612 месяца назад
In this video, we walk you through the process of connecting Google Drive to your settings and seamlessly integrating your files with ease. Starting from the top, we'll guide you through accessing the settings and ensuring Google Drive is connected. If it's not, we'll show you how to connect it quickly. Once connected, we demonstrate adding files directly from Google Drive, such as invoices, an...
Comparing GPT-3.5, GPT-4, and GPT-4.0: Create Spreadsheets with ChatGPT for Excel and Google Sheets
Просмотров 1172 месяца назад
In this video, we compare the three main versions of GPT on the ChatGPT website: GPT-3.5, GPT-4, and GPT-4.0. We specifically look at how they differ when creating tables, Excel files and Google Sheets. Timestamps: 00:00 Intro to comparing the versions of ChatGPT 00:39 ChatGPT 3.5 02:48 ChatGPT 4.0 05:48 ChatGPT 4.0o 07:08 Creating excel files vs copy and pasting from ChatGPT 07:28 Gemini in Go...
How to Assign Script to Drawings and Why You Should Use This Instead of Inserting Images Over Cell
Просмотров 1783 месяца назад
How to Assign Script to Drawings and Why You Should Use This Instead of Inserting Images Over Cell
How to Set Home Page in Chrome with a Google Sheet!
Просмотров 2493 месяца назад
How to Set Home Page in Chrome with a Google Sheet!
How to Sum Columns in Google Sheets - Fastest Trick!
Просмотров 1104 месяца назад
How to Sum Columns in Google Sheets - Fastest Trick!
How to Create a Table in Google Sheets
Просмотров 6614 месяца назад
How to Create a Table in Google Sheets
How to Hide and Unhide Columns and Rows in Google Sheets
Просмотров 3754 месяца назад
How to Hide and Unhide Columns and Rows in Google Sheets
Clone Your Google Sheets Tabs in Seconds 😱 FREE Script in Description! 🎁
Просмотров 1594 месяца назад
Clone Your Google Sheets Tabs in Seconds 😱 FREE Script in Description! 🎁
Change Color of the Dropdown Chips in Google Sheets
Просмотров 5575 месяцев назад
Change Color of the Dropdown Chips in Google Sheets
Streamline Your Business with Our Toolkit | Product Creation & Inventory Management Spreadsheet
Просмотров 1895 месяцев назад
Streamline Your Business with Our Toolkit | Product Creation & Inventory Management Spreadsheet
How to Modify Your Bookkeeping Spreadsheet to Accept Custom Currencies
Просмотров 2067 месяцев назад
How to Modify Your Bookkeeping Spreadsheet to Accept Custom Currencies
Creating Invoices Using Google Sheets and Slides (or Docs): Tech Talk Bonus January 20, 2024
Просмотров 5987 месяцев назад
Creating Invoices Using Google Sheets and Slides (or Docs): Tech Talk Bonus January 20, 2024
ChatGPT + Google Sheets: Using these platforms together
Просмотров 4028 месяцев назад
ChatGPT Google Sheets: Using these platforms together
12 Days of Giveaways - 2024 Goals Planner Walkthrough - FREE GIFT IN CAPTION!
Просмотров 1919 месяцев назад
12 Days of Giveaways - 2024 Goals Planner Walkthrough - FREE GIFT IN CAPTION!
Selling Spreadsheet Templates? Make sure you do this!
Просмотров 4869 месяцев назад
Selling Spreadsheet Templates? Make sure you do this!
Ready to Sell Your Google Sheet? Let's prepare it, protect it and share the link!
Просмотров 2 тыс.9 месяцев назад
Ready to Sell Your Google Sheet? Let's prepare it, protect it and share the link!
Creating Google Sheets That Sell: Function and Design for Beginners
Просмотров 1,4 тыс.9 месяцев назад
Creating Google Sheets That Sell: Function and Design for Beginners
Selling Google Sheets as a Digital Product: What Spreadsheet to Sell and Where to Sell Them! 🤑
Просмотров 1,1 тыс.9 месяцев назад
Selling Google Sheets as a Digital Product: What Spreadsheet to Sell and Where to Sell Them! 🤑
Selling & Monetizing Google Sheets as a Digital Product: Inside Scoop on Revenue and Demand 🤯
Просмотров 6359 месяцев назад
Selling & Monetizing Google Sheets as a Digital Product: Inside Scoop on Revenue and Demand 🤯
How to Create a Force Copy Link for Your Google Spreadsheet Templates
Просмотров 5859 месяцев назад
How to Create a Force Copy Link for Your Google Spreadsheet Templates
Find and Replace Function in Google Sheets - Work smarter not harder :)
Просмотров 1339 месяцев назад
Find and Replace Function in Google Sheets - Work smarter not harder :)
Deep Dive Into Holiday Gift Spreadsheet
Просмотров 18210 месяцев назад
Deep Dive Into Holiday Gift Spreadsheet
Checkboxes and Sparklines in Google Sheets 😍
Просмотров 1,6 тыс.10 месяцев назад
Checkboxes and Sparklines in Google Sheets 😍
Find and Replace Data Within Your Formulas in a Specific Range in Google Sheets
Просмотров 53211 месяцев назад
Find and Replace Data Within Your Formulas in a Specific Range in Google Sheets
How To Link to Cells - Jump to Section in Google Sheets! 🦘
Просмотров 1,8 тыс.11 месяцев назад
How To Link to Cells - Jump to Section in Google Sheets! 🦘
Thank you ❤
I'm really looking forward to this summit. i can't wait...
I got Adrienne's awesome Business Dashboard and I love it!
Watching the replay. How do we get the bookmarks to be an icon only?
In Google Chrome, when you save a bookmark, erase the title. You can save the bookmark to the toolbar and Google Chrome will replace the title with their favicon. hth
How did you do the fireworks Melinda?!
pretty sure it's a Chrome voice command thing when you say a keyword lol
Is this spreadsheet mean for the end customer or the nail salon admin?
the salon admin!
Did not find this helpful. Can hardly see the actual formula and the screen is blurry.
Exactly what I was looking for ! Merci !
Hi. What if the cell thats edited is in a table and has a formula in it? I can get the extension to work by manually editing the cell, but I want the timestamp to appear when the value of the actual cell is changed due to formula reaction
i couldn't find anything on how to do this so your video is sooo valuable!! love how easy you broke everything down, we appreciate it!
woww nice template there.. can You share it for me please..
Looks interesting!! Canada does our dates different
great viD thank you! how do I make a calendar based only on Sundays, Thursdays & Wednesdays in a the month? 🙏🙏🙏
Thanks a million.
@@jillianrose1831 you’re very welcome!😊
In google sheets I’m doing a self graded protein synthesis practice with different mutations. Any ideas for a bonus?
function openLink(){ var url = "yoururl"; var htmlOutput = HtmlService.createHtmlOutput('<script>window.open("' + url + '");google.script.host.close();</script>'); SpreadsheetApp.getUi().showModalDialog(htmlOutput, "opening link"); }
Helpful thanks
Thanks for the tip. This is just what I was looking for.
Poor Mel... Thank you for powering through. This was so useful... thank you so much! <3
I LOVE them!
You helped me a lot! Thanks
@@manueldust2361 yay! You’re very welcome!
i past her up!
I dont know why but it keeps saying "VALUE". I did what u did but the True is not highlighting
@@royal3161 it may be a character out of place. Put your formula in ChatGPT and ask it what’s wrong with your Google sheets formula ☺️
@@spreadsheetables already fixed it 😅. Thanks for this video 😊
@@royal3161 awesome! You’re very welcome😊
This don't work I'm still getting clicks for irrelevant search terms. Like example I got 120 clicks and 0 sales from another shops name.
@@gravesfamilycreationsllc3350 the search term will still show up even if you turn off (with the previous data) , but you will no longer be charged for the clicks that come from those search terms
Thank you, just what I needed!
Do you just create folders in Canva for your template banks and image banks?
@@StarrConsulting no folders. We use one Canva document per each format, then link them in Google sheets. We found that creating folders in Canva didn’t do much for us😂 we need direct links for things.
thannk youu !!!
I’ve got another piece to add to your toolkit. I’ll drop it inside the fb group
Hello! Question, what if I only want a specific column to return or show in the filter tab? Thanks!
Hi there! Great question! In that case you’ll only select the column you want to display in the results. So for example, instead of =filter(A2:E…., you will use =filter(A2:A….. hope that helps!
Are these available in Tier 1?
@@tshay8946 no, but they are available in vip 🥰
Is there a way to make it go the other way? So the finish line is on the right?
Yes
Hi, I also make spreadsheets on my channel but for e-commerce so it's good to see a fellow spreadsheet person with a channel. Anyway, I've never used the media features of Google sheets so thanks for the video!
I'd like a .wav file to play based on certain responses in google sheets.
Can I ask you to share link to this SMART google sheets please
Thank you very much!
thank you so much ! informative and straight to the point.
I need to know how to record the "edited" date & time of a cells in various rows , in the same column. Can you help
Hoping someone will read this how do i make a mock up for a Google sheet template, i have tried saving mine in jpg so that i create mock up in canva but am not able to, do i screenshot or what do i do? I need help
Hi there! Yes, that’s correct! You will screenshot the portion of your spreadsheet you want to display and drop that into your Canva mockup 😊
@@spreadsheetables awwwee thank you so much for answering I was really stuck.
@@beautifulplaces6328 you’re very welcome!
Great to tutorial. Much appreciated. Although is there a way to password lock (no view) the do not edit sheet? In the case the formula is propretary?
I have concerns about how to use it. Could you please make a video for beginners?
Thank you. your saved life.
Love using drawings for script buttons! Question… every once in a while when I open my spreadsheet, my buttons have moved slightly. Is there some way to keep this from happening?
Ohh yeas, that’s a pain! only quick fix is to click on a different tab and then back into the main tab where the button is. Other than that I have no other trick to prevent it from moving. Happens to images as well 😩
Very tricky to do that way.
Thank you. It is giving an idea....
Andrew
Dankeschön, das war sehr hilfreich!
Make it excel compatible and you quadruple your market
That was so helpful! For those asking, its under Extentions > Apps Script
I have a google drive nested folder structure i want to package with google sheets in specific folders, docs and pdf's in others. how would you think to package this all into a digital product to sell in 1 click? bonus if you know how to add a looker studio dashboard to that product. :x