WorkflowWisdom
WorkflowWisdom
  • 333
  • 136 702
Google Sheets: Conditional Formatting Based on Another Cell (Checkboxes)
In this video, learn how to use conditional formatting in Google Sheets based on another cell!
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
This powerful feature allows you to automatically change the appearance of a cell or range of cells when specific conditions are met, enhancing data analysis and visualization. Whether you're tracking data, creating dynamic dashboards, or simplifying your spreadsheets, this step-by-step tutorial will guide you through setting up custom rules and formatting styles. By the end of this video, you'll be able to apply conditional formatting efficiently to highlight key information in your Google Sheets.
Don't forget to like, subscribe, and hit the notification bell for more helpful Google Sheets tips and tricks!
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
================================
Share: ua-cam.com/video/2prOWRbR5mM/v-deo.html 👈
================================
Affiliate Disclaimer:
While we may receive affiliate compensation for reviews / promotions on this channel page, we always offer honest opinions, relevant experiences, and genuine views related to the product or service itself. Our goal is to help you make the best purchasing decisions. However, the views and opinions expressed are ours only. As always you should do your own due diligence to verify any claims, results and statistics before making any kind of purchase. Clicking links or purchasing products recommended on this page may generate income for this channel and website from affiliate commissions, and you should assume we are compensated for any purchases you make.
================================
Переглядів: 29

Відео

3 Ways Google Sheets Can Help you Keep Track Daily Activities (Free Template)
Переглядів 1022 години тому
In this video, explore 3 easy ways Google Sheets can help you keep track of your daily activities and stay organized. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 From creating customizable to-do lists and creating your own habit tracker, Google Sheets offers a powerful and simple solution to streamline your day-to-day tasks. Wh...
Google Sheets: Fill out Grades Based off Marks (using VLOOKUP)
Переглядів 497 годин тому
In this video, you’ll learn how to fill out grades in Google Sheets based on marks! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 I’ll guide you step-by-step through setting up a grade scale and using VLOOKUP to automatically assign grades to student scores. This powerful function helps you save time and ensures accuracy by match...
Google Sheets: Use the Filter Function on Multiple Sheets (Named Ranges)
Переглядів 2199 годин тому
In this video, learn how to use the Filter function on multiple sheets in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 This tutorial covers step-by-step instructions on setting up named ranges, applying the Filter function, and combining data from different sheets efficiently. Whether you're managing large dataset...
Google Sheets: Convert to Table Option Greyed Out? (Pre-Built Tables)
Переглядів 6612 годин тому
In this video, learn why the "Convert to Table" option might be greyed out in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 If you're trying to organize your data into a table format but can't access the option, don't worry-I'll cover common reasons, including data formatting issues and data selection errors. Wheth...
Google Sheets: Create Multiple Dependent Dropdown Lists for 1000 rows! (Data Validation)
Переглядів 30614 годин тому
In this video, learn how to create multiple dependent dropdown lists in Google Sheets for up to 1,000 rows! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 This step-by-step tutorial will guide you through setting up cascading dropdowns that dynamically change based on your selections, perfect for organizing data efficiently. Wheth...
Google Sheets: How to go back to a Previous Version? (Restore Spreadsheet)
Переглядів 5916 годин тому
In this video, you'll learn how to go back to a previous version in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you made an accidental change or need to recover old data, this tutorial will guide you through the steps to view and restore earlier versions of your spreadsheet. I'll cover how to access the v...
Google Sheets: ARRAYFORMULA and VLOOKUP Functions (Rearrange Column Order)
Переглядів 10419 годин тому
In this video, learn how to use the ARRAYFORMULA and VLOOKUP functions in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 I'll guide you step-by-step through practical examples that demonstrate how to use ARRAYFORMULA to apply VLOOKUP across multiple rows automatically, saving you time, reducing manual effort and mor...
How to Use the Gantt Chart Template in Google Sheets (Project Management)
Переглядів 117День тому
In this video, learn how to use a Gantt chart template in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 I'll guide you step-by-step through setting up the template, customizing it for your project’s needs, and tracking tasks, deadlines, and progress, to effectively plan and manage your projects. Whether you're mana...
How to Use the Invoice Template in Google Sheets (Free & Easy Template)
Переглядів 70День тому
In this video, learn how to use the Invoice Template in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're a small business owner, freelancer, or need a quick invoicing solution, this tutorial will show you how to customize and format the template to fit your needs. Learn how to input client details, add ...
How to Create a Habit Tracker in Google Sheets! (Progress Bar)
Переглядів 77День тому
In this video, you'll learn how to create a simple and effective habit tracker in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 ✅Download the template from this video for free: docs.google.com/spreadsheets/d/12FP83M6tedXcVRP49bK18zswNdwaLDYIlOzsYOpKfBM/edit?usp=sharing 👈 Whether you're aiming to build positive habi...
How to INSERT a FUNCTION in Google Sheets (Quick Tutorial)
Переглядів 76День тому
In this video, you'll learn how to insert a function in Google Sheets quickly and easily. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're new to spreadsheets or just looking for a refresher, I'll guide you step-by-step on using built-in functions like SUM, AVERAGE, and more. Discover how to select the right cells, ap...
How to Fix the #N/A! ERROR in Google Sheets (IFNA & IFERROR)
Переглядів 4714 днів тому
In this video, we'll show you how to fix the #N/A error in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 The #N/A error commonly appears when a formula can't find the data it's looking for, especially in the function VLOOKUP. I'll walk through simple steps to troubleshoot and resolve this issue, including how to ad...
Google Sheets: #ERROR! Explained & How to Fix It! (Formulas Parse Error)
Переглядів 7014 днів тому
In this video, learn about the #ERROR! and How to fix it on Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 I will break down the common #ERROR! message in Google Sheets and explain why it occurs and how to fix it quickly. Whether you’re dealing with broken formulas, unsupported functions, or missing references, I’ve...
Google Sheets: Combine Cell Contents in 4 ways (JOIN,CONCAT)
Переглядів 6014 днів тому
In this video, you'll learn four easy ways to combine cell contents in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you want to merge text, numbers, or both, we’ll show you step-by-step techniques to simplify your data management. I'll cover using the `&` symbol and `CONCATENATE` function, and more for adv...
How to Add a Dropdown List on Google Sheets (Independent List)
Переглядів 13014 днів тому
How to Add a Dropdown List on Google Sheets (Independent List)
What is #NUM! Error and How to Fix it in Google Sheets (Invalid Number)
Переглядів 2414 днів тому
What is #NUM! Error and How to Fix it in Google Sheets (Invalid Number)
Google Sheets: Conditional Formatting to Highlight Errors (Custom Formula)
Переглядів 11214 днів тому
Google Sheets: Conditional Formatting to Highlight Errors (Custom Formula)
Google Sheets: #NAME? Error Explained and Fixed! (4 Examples)
Переглядів 4521 день тому
Google Sheets: #NAME? Error Explained and Fixed! (4 Examples)
What is #VALUE! Error and How to Fix it in Google Sheets (Easy Fix)
Переглядів 5921 день тому
What is #VALUE! Error and How to Fix it in Google Sheets (Easy Fix)
10 Most Powerful Formulas in Google Sheets! (Functions You Should Know)
Переглядів 46621 день тому
10 Most Powerful Formulas in Google Sheets! (Functions You Should Know)
Google Sheets: Formula Parse Error Explained! (Google Sheets Errors)
Переглядів 19721 день тому
Google Sheets: Formula Parse Error Explained! (Google Sheets Errors)
How to Extract Top 3 Values from Range in Google Sheets (LARGE Function)
Переглядів 11821 день тому
How to Extract Top 3 Values from Range in Google Sheets (LARGE Function)
How to Create a Header Row in Google Sheets (Format Text)
Переглядів 13521 день тому
How to Create a Header Row in Google Sheets (Format Text)
Google Sheets: How to Replace Text with a Blank Cell (Find & Replace)
Переглядів 8028 днів тому
Google Sheets: How to Replace Text with a Blank Cell (Find & Replace)
How to Create a Search Bar in Google Sheets (Useful & Practical)
Переглядів 17928 днів тому
How to Create a Search Bar in Google Sheets (Useful & Practical)
Named Ranges Vs. Table References in Google Sheets (in Formula Usage)
Переглядів 103Місяць тому
Named Ranges Vs. Table References in Google Sheets (in Formula Usage)
Google Sheets: Why do you get #REF! Error? (How to Deal with It)
Переглядів 61Місяць тому
Google Sheets: Why do you get #REF! Error? (How to Deal with It)
Google Sheets: How to FIX #DIV/0 Error (Easy FIX)
Переглядів 91Місяць тому
Google Sheets: How to FIX #DIV/0 Error (Easy FIX)
Google Sheets: How to Place Additional Text to your Cells (Find & Replace)
Переглядів 121Місяць тому
Google Sheets: How to Place Additional Text to your Cells (Find & Replace)

КОМЕНТАРІ

  • @WorkflowWisdom
    @WorkflowWisdom 3 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @udayhema9098
    @udayhema9098 3 дні тому

    Thank you ❤

  • @trevorturner4432
    @trevorturner4432 4 дні тому

    Just to let you know the like button is not counting, great video you always make them on things I didn't about and well explained thanks.

    • @WorkflowWisdom
      @WorkflowWisdom 3 дні тому

      Thanks for that! And about the like button not working, then it is likely a UA-cam glitch. Hope they will fix it soon. But thanks for letting me know.

  • @SkifNomadcat
    @SkifNomadcat 4 дні тому

    Thank you for your tutorials so much! The topic is a bit niche, but it is precisely what I need 💜

  •  6 днів тому

    You can use absolute reference instead of typing the name like this: =DGET($h$1:$j:$16, $C$2, { $H$1; c2}) Of course this is less descriptive (but often faster to do).

  • @alanyevenes
    @alanyevenes 7 днів тому

    Nice video! Thanks a lot 😊

  • @afvejlani
    @afvejlani 9 днів тому

    Hi.. Can you show the function to serialize the number excluding the hidden rows in google sheets?

    • @WorkflowWisdom
      @WorkflowWisdom 2 дні тому

      As I've already mentioned in the video, if you want to exclude hidden cells, just write the function code then prepend it with 10. In the example, that would be 10 then 9, so your formula would be SUBTOTAL(109,[range]). Hope this explains it.

  • @ImranAnsari-PSS
    @ImranAnsari-PSS 9 днів тому

    Fabulous & so Helpful trick for Scroll bar in Google Sheet

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 10 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @TwinShards
    @TwinShards 12 днів тому

    Ty! Exactly what i was looking for!

  • @Bendget
    @Bendget 15 днів тому

    Thank you very much🌹

  • @ThatBoomerDude56
    @ThatBoomerDude56 15 днів тому

    I don't want to underline text. I want to have a bold underline under a line of cells.

    • @WorkflowWisdom
      @WorkflowWisdom 3 дні тому

      In adding a bold underline to you cells, just go to borders, first select how thick you want you line to be with the border style, then select bottom border.

    • @ThatBoomerDude56
      @ThatBoomerDude56 3 дні тому

      @@WorkflowWisdom Thanks. I found it a few days ago.

    • @WorkflowWisdom
      @WorkflowWisdom 2 дні тому

      Great you found a solution. Sorry for the late reply on your first comment.

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 17 днів тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @fschnidi
    @fschnidi 18 днів тому

    hi! does not work for me on mac for some reason (safari)

    • @WorkflowWisdom
      @WorkflowWisdom 16 днів тому

      Make sure to hold on to/keep pressing the Ctrl or Command Key on your keyboard when you press the arrow keys to get to the end of your data.

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom 24 дні тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @mreighties2860
    @mreighties2860 26 днів тому

    Hello, At timestamp 5:16 Workflow tells you to create the second dropdown and then drag it down. Then she says we need to change the reference cells of the row the dropdowns are referring to, but we don't need to change every dropdown especially if you have 750 or more. After creating the 1st second dropdown in cell B3 just click the editing tool at the bottom of the dropdown and in the range you will see it is set as "ABSOLTE" with dollar marks. But we can remove those dollar marks and then click "Done". Now the range is set to "RELATIVE" which means if we drag the dropdown down the ranges in each dropdown will change to the "relative" row it is in or it is referring to and as you select different options in the first dropdown, the second dropdown will show only options chosen in the first dropdown. So after choosing an option in the first dropdown no matter which row, the second dropdown will only show options for that choice. I have known about this since August 26, 2022 when I created my first spreadsheet using this method instead of a script. There are plenty of you tube videos showing this method in action. James :)

    • @WorkflowWisdom
      @WorkflowWisdom 24 дні тому

      Thanks for sharing a different methods this can also be done.

  • @IPlayIWA
    @IPlayIWA 27 днів тому

    Thank you. Keep up the great work.

  • @gothamfury
    @gothamfury 28 днів тому

    This is a very helpful video. Thank you :)

  • @IPlayIWA
    @IPlayIWA 29 днів тому

    Thank you very much for doing this. I always wondered what this would look like and you explained it very well. Keep up the great work.

  • @trevorturner4432
    @trevorturner4432 29 днів тому

    I love your explanations of how to do things in google sheets, but I tried this on my iPhone and the conditional format is not there, any idea? Thanks

    • @WorkflowWisdom
      @WorkflowWisdom 24 дні тому

      I'm not sure how you can't see it, because I'm guessing it's the same with android phones, just make sure you have selected cells that you want to format, then go to the ICON that has a letter A in it at the top, once selected, the format options will appear, scroll all the way up and you'll see Conditional formatting option, just above the Format cell option. Hope this helps!

    • @trevorturner4432
      @trevorturner4432 24 дні тому

      Thanks for replying but apparently it doesn’t work on iPhone, keep up the good work I love your videos all the best TT

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @seandonnelly5589
    @seandonnelly5589 Місяць тому

    I can't replicate this unfortuantley. Perhaps my data set is different

    • @WorkflowWisdom
      @WorkflowWisdom Місяць тому

      Difficult to say what the issue might be without more info.

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 Місяць тому

    Thanks

  • @Allen-L-Canada
    @Allen-L-Canada Місяць тому

    can't see your other 2 dark-mode videos at the corner.

    • @WorkflowWisdom
      @WorkflowWisdom 28 днів тому

      I've added the cards for the videos I was talking about in the video. You should be able to find them by clicking in the top corner of the video.

  • @alexyehorov1
    @alexyehorov1 Місяць тому

    great video. Thank you very much :)

  • @gothamfury
    @gothamfury Місяць тому

    Do you have or can you provide supplementary videos on which formulas work with or don't work with ARRAYFORMULA?

    • @WorkflowWisdom
      @WorkflowWisdom 28 днів тому

      Will do, so make sure to subscribe so you can get updated when I upload these supplementary videos.

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈

  • @WorkflowWisdom
    @WorkflowWisdom Місяць тому

    ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈