- 333
- 136 702
WorkflowWisdom
United States
Приєднався 22 сер 2023
WorkflowWisdom is your ultimate destination for mastering Google Sheets in bite-sized, easy-to-understand tutorials.
Whether you're a beginner or an experienced user, this channel is designed to help you unleash the power of Google Sheets for everyday tasks, business use, or creative projects.
Our expert hosts will guide you through the ins and outs of functions, formulas, data visualization, and more with step-by-step instructions and handy tips.
With the help of the videos here on WorkflowWisdom, you can transform your workflow and achieve spreadsheet success in no time!
So subscribe and unlock the wisdom of efficient, productive, and smarter working with Google Sheets.
Whether you're a beginner or an experienced user, this channel is designed to help you unleash the power of Google Sheets for everyday tasks, business use, or creative projects.
Our expert hosts will guide you through the ins and outs of functions, formulas, data visualization, and more with step-by-step instructions and handy tips.
With the help of the videos here on WorkflowWisdom, you can transform your workflow and achieve spreadsheet success in no time!
So subscribe and unlock the wisdom of efficient, productive, and smarter working with Google Sheets.
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.
================================
✅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)
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Thank you ❤
You're welcome 😊
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.
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.
Thank you for your tutorials so much! The topic is a bit niche, but it is precisely what I need 💜
Glad it was helpful!
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).
Thanks for sharing.
Nice video! Thanks a lot 😊
Thank you too!
Hi.. Can you show the function to serialize the number excluding the hidden rows in google sheets?
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.
Fabulous & so Helpful trick for Scroll bar in Google Sheet
Thanks. Glad it helped.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Ty! Exactly what i was looking for!
Happy it helped.
Thank you very much🌹
You're welcome 😊
I don't want to underline text. I want to have a bold underline under a line of cells.
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.
@@WorkflowWisdom Thanks. I found it a few days ago.
Great you found a solution. Sorry for the late reply on your first comment.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
hi! does not work for me on mac for some reason (safari)
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.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
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 :)
Thanks for sharing a different methods this can also be done.
Thank you. Keep up the great work.
Thank you too!
This is a very helpful video. Thank you :)
Glad it was helpful!
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.
Glad it was helpful!
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
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!
Thanks for replying but apparently it doesn’t work on iPhone, keep up the good work I love your videos all the best TT
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
I can't replicate this unfortuantley. Perhaps my data set is different
Difficult to say what the issue might be without more info.
Thanks
Welcome
can't see your other 2 dark-mode videos at the corner.
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.
great video. Thank you very much :)
You are welcome!
Do you have or can you provide supplementary videos on which formulas work with or don't work with ARRAYFORMULA?
Will do, so make sure to subscribe so you can get updated when I upload these supplementary videos.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈