Spreadsheetables
Spreadsheetables
  • Видео 144
  • Просмотров 134 555

Видео

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! 🦘

Комментарии

  • @djmichi1257
    @djmichi1257 День назад

    Thank you ❤

  • @DianaMayeDesigns
    @DianaMayeDesigns 3 дня назад

    I'm really looking forward to this summit. i can't wait...

  • @johnnakirk7365
    @johnnakirk7365 4 дня назад

    I got Adrienne's awesome Business Dashboard and I love it!

  • @kaajalnagindas4986
    @kaajalnagindas4986 4 дня назад

    Watching the replay. How do we get the bookmarks to be an icon only?

    • @DianaMayeDesigns
      @DianaMayeDesigns 3 дня назад

      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

  • @Sky-yj8wx
    @Sky-yj8wx 11 дней назад

    How did you do the fireworks Melinda?!

    • @spreadsheetables
      @spreadsheetables 8 дней назад

      pretty sure it's a Chrome voice command thing when you say a keyword lol

  • @Sky-yj8wx
    @Sky-yj8wx 11 дней назад

    Is this spreadsheet mean for the end customer or the nail salon admin?

  • @justcourt5326
    @justcourt5326 14 дней назад

    Did not find this helpful. Can hardly see the actual formula and the screen is blurry.

  • @joseph1d697
    @joseph1d697 16 дней назад

    Exactly what I was looking for ! Merci !

  • @pedrov2604
    @pedrov2604 18 дней назад

    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

  • @jazminekwon7831
    @jazminekwon7831 20 дней назад

    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!

  • @usamahhilaby8415
    @usamahhilaby8415 21 день назад

    woww nice template there.. can You share it for me please..

  • @Sky-yj8wx
    @Sky-yj8wx 23 дня назад

    Looks interesting!! Canada does our dates different

  • @ShaharGalnoor
    @ShaharGalnoor 23 дня назад

    great viD thank you! how do I make a calendar based only on Sundays, Thursdays & Wednesdays in a the month? 🙏🙏🙏

  • @jillianrose1831
    @jillianrose1831 23 дня назад

    Thanks a million.

  • @michellerichards2067
    @michellerichards2067 25 дней назад

    In google sheets I’m doing a self graded protein synthesis practice with different mutations. Any ideas for a bonus?

  • @ChrisHouk-z2t
    @ChrisHouk-z2t 25 дней назад

    function openLink(){ var url = "yoururl"; var htmlOutput = HtmlService.createHtmlOutput('<script>window.open("' + url + '");google.script.host.close();</script>'); SpreadsheetApp.getUi().showModalDialog(htmlOutput, "opening link"); }

  • @danimotherofchickens479
    @danimotherofchickens479 28 дней назад

    Helpful thanks

  • @VolcanoEarth
    @VolcanoEarth 28 дней назад

    Thanks for the tip. This is just what I was looking for.

  • @DianaMayeDesigns
    @DianaMayeDesigns Месяц назад

    Poor Mel... Thank you for powering through. This was so useful... thank you so much! <3

  • @iRevCMD
    @iRevCMD Месяц назад

    I LOVE them!

  • @manueldust2361
    @manueldust2361 Месяц назад

    You helped me a lot! Thanks

  • @mileszito24
    @mileszito24 Месяц назад

    i past her up!

  • @royal3161
    @royal3161 Месяц назад

    I dont know why but it keeps saying "VALUE". I did what u did but the True is not highlighting

    • @spreadsheetables
      @spreadsheetables Месяц назад

      @@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 ☺️

    • @royal3161
      @royal3161 Месяц назад

      @@spreadsheetables already fixed it 😅. Thanks for this video 😊

    • @spreadsheetables
      @spreadsheetables Месяц назад

      @@royal3161 awesome! You’re very welcome😊

  • @gravesfamilycreationsllc3350
    @gravesfamilycreationsllc3350 Месяц назад

    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.

    • @spreadsheetables
      @spreadsheetables Месяц назад

      @@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

  • @joeychen7165
    @joeychen7165 Месяц назад

    Thank you, just what I needed!

  • @StarrConsulting
    @StarrConsulting Месяц назад

    Do you just create folders in Canva for your template banks and image banks?

    • @spreadsheetables
      @spreadsheetables Месяц назад

      @@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.

  • @SavvyPlannerStudioCo
    @SavvyPlannerStudioCo Месяц назад

    thannk youu !!!

  • @StarrConsulting
    @StarrConsulting Месяц назад

    I’ve got another piece to add to your toolkit. I’ll drop it inside the fb group

  • @Ria0fd
    @Ria0fd Месяц назад

    Hello! Question, what if I only want a specific column to return or show in the filter tab? Thanks!

    • @spreadsheetables
      @spreadsheetables Месяц назад

      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!

  • @tshay8946
    @tshay8946 Месяц назад

    Are these available in Tier 1?

    • @spreadsheetables
      @spreadsheetables Месяц назад

      @@tshay8946 no, but they are available in vip 🥰

  • @samanthastolz4383
    @samanthastolz4383 2 месяца назад

    Is there a way to make it go the other way? So the finish line is on the right?

  • @markteachsellers
    @markteachsellers 2 месяца назад

    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!

  • @fireandice2301
    @fireandice2301 2 месяца назад

    I'd like a .wav file to play based on certain responses in google sheets.

  • @andreiyserdniy
    @andreiyserdniy 2 месяца назад

    Can I ask you to share link to this SMART google sheets please

  • @user-ii5bi6lc1d
    @user-ii5bi6lc1d 2 месяца назад

    Thank you very much!

  • @Gene75135
    @Gene75135 2 месяца назад

    thank you so much ! informative and straight to the point.

  • @CFerns100
    @CFerns100 2 месяца назад

    I need to know how to record the "edited" date & time of a cells in various rows , in the same column. Can you help

  • @beautifulplaces6328
    @beautifulplaces6328 2 месяца назад

    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

    • @spreadsheetables
      @spreadsheetables 2 месяца назад

      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 😊

    • @beautifulplaces6328
      @beautifulplaces6328 2 месяца назад

      @@spreadsheetables awwwee thank you so much for answering I was really stuck.

    • @spreadsheetables
      @spreadsheetables 2 месяца назад

      @@beautifulplaces6328 you’re very welcome!

  • @sunnyempire
    @sunnyempire 2 месяца назад

    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?

  • @hancho_nacho
    @hancho_nacho 2 месяца назад

    I have concerns about how to use it. Could you please make a video for beginners?

  • @3ugeneS
    @3ugeneS 2 месяца назад

    Thank you. your saved life.

  • @sarahhill3773
    @sarahhill3773 3 месяца назад

    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?

    • @spreadsheetables
      @spreadsheetables 3 месяца назад

      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 😩

  • @user-oe6bu1ud3w
    @user-oe6bu1ud3w 3 месяца назад

    Very tricky to do that way.

  • @hendesemabedi
    @hendesemabedi 3 месяца назад

    Thank you. It is giving an idea....

  • @AndrewLouwrens
    @AndrewLouwrens 3 месяца назад

    Andrew

  • @SZF_LOGISTIK
    @SZF_LOGISTIK 3 месяца назад

    Dankeschön, das war sehr hilfreich!

  • @timz2917
    @timz2917 4 месяца назад

    Make it excel compatible and you quadruple your market

  • @britttttttttttt
    @britttttttttttt 4 месяца назад

    That was so helpful! For those asking, its under Extentions > Apps Script

  • @johnrichmond007
    @johnrichmond007 4 месяца назад

    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