WorkflowWisdom
WorkflowWisdom
  • 293
  • 93 421
Custom Size for your Rows And Columns in Google Sheets (Resize Option)
In this video, learn how to customize the size of rows and columns in Google Sheets!
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Whether you're organizing data for a project, creating a budget, or managing a schedule, adjusting the row height and column width is essential for clarity and efficiency. I'll cover step-by-step instructions on resizing multiple rows and columns at once, setting exact dimensions, and tips to keep your spreadsheet looking neat and organized. Perfect for beginners and experienced users alike, this guide will help you take control of your Google Sheets layout effortlessly.
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: th-cam.com/video/zEP0VL72Xkc/w-d-xo.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

วีดีโอ

Google Sheets: Attendance Tracker in Percentage (With Progress Bar)5:32Google Sheets: Attendance Tracker in Percentage (With Progress Bar)
Google Sheets: Attendance Tracker in Percentage (With Progress Bar)
มุมมอง 5220 ชั่วโมงที่ผ่านมา
In this video, you'll learn how to create an attendance tracker in percentage in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Perfect for teachers, managers, or event organizers, this template automatically converts attendance data into easy-to-read percentages. Whether you're tracking classroom attendance, employ...
Generate a Scannable BarCode in Google Sheets (IMAGE Function)7:42Generate a Scannable BarCode in Google Sheets (IMAGE Function)
Generate a Scannable BarCode in Google Sheets (IMAGE Function)
มุมมอง 7122 ชั่วโมงที่ผ่านมา
In this video, you'll learn how to generate a scannable barcode in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're organizing inventory, creating event tickets, or managing product lists, this step-by-step tutorial will guide you through the process. I'll cover how to use Google Sheets' built-in functi...
How to Use the SEQUENCE Function in Google Sheets (Start and Step)4:06How to Use the SEQUENCE Function in Google Sheets (Start and Step)
How to Use the SEQUENCE Function in Google Sheets (Start and Step)
มุมมอง 101วันที่ผ่านมา
In this video, you'll learn how to use the SEQUENCE function in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 I'll walk you through the basics of the SEQUENCE function, showing you how to generate sequences of numbers, dates, or even custom patterns to create dynamic lists and tables with ease. Whether you're organ...
How to Use the CELL Function in Google Sheets (Information Type)4:20How to Use the CELL Function in Google Sheets (Information Type)
How to Use the CELL Function in Google Sheets (Information Type)
มุมมอง 124วันที่ผ่านมา
In this video, let’s explore how to use the CELL function in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're looking to identify cell formatting, address, or content type, the CELL function is a versatile tool that can enhance your data management skills. I'll walk you through the syntax, provide pract...
Google Sheets: How to Use the COUNTUNIQUEIFS Function (Quick Count)2:40Google Sheets: How to Use the COUNTUNIQUEIFS Function (Quick Count)
Google Sheets: How to Use the COUNTUNIQUEIFS Function (Quick Count)
มุมมอง 94วันที่ผ่านมา
In this video, I will show you how to use the COUNTUNIQUEIFS function in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Learn how to count unique values based on multiple criteria, making your data analysis more accurate and efficient. I'll walk you through step-by-step instructions, practical examples, and tips to ...
Easy Trick to Make a Dark Mode Toggle in Google Sheets (Checkbox)3:04Easy Trick to Make a Dark Mode Toggle in Google Sheets (Checkbox)
Easy Trick to Make a Dark Mode Toggle in Google Sheets (Checkbox)
มุมมอง 82วันที่ผ่านมา
In this video, I will show you an easy trick on how to add a Dark Mode toggle in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Follow along as I demonstrate step-by-step how to create a simple toggle like feature that allows you to switch between light and dark modes effortlessly. Perfect for reducing eye strain an...
How to Quickly Create an Inline Array in Google Sheets (Curly Brackets)2:10How to Quickly Create an Inline Array in Google Sheets (Curly Brackets)
How to Quickly Create an Inline Array in Google Sheets (Curly Brackets)
มุมมอง 81วันที่ผ่านมา
In this video, learn how to quickly create an inline array in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Discover the step-by-step process to streamline your data organization and improve efficiency. Whether you're a beginner or an experienced user, this tutorial will guide you through the essential techniques t...
Google Sheets: Get the Average of your Combined Data from Multiple Sheets (ARRAYFORMULA)4:07Google Sheets: Get the Average of your Combined Data from Multiple Sheets (ARRAYFORMULA)
Google Sheets: Get the Average of your Combined Data from Multiple Sheets (ARRAYFORMULA)
มุมมอง 53วันที่ผ่านมา
In this video, learn how to get the average of combined data from multiple sheets in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're managing budgets, tracking sales, or compiling survey results, learning how to efficiently aggregate and analyze your data is crucial. I'll cover step-by-step instruction...
Google Sheets: Exclude Hidden or Filtered Rows in your Formula (SUBTOTAL FUNCTION)4:47Google Sheets: Exclude Hidden or Filtered Rows in your Formula (SUBTOTAL FUNCTION)
Google Sheets: Exclude Hidden or Filtered Rows in your Formula (SUBTOTAL FUNCTION)
มุมมอง 86วันที่ผ่านมา
In this video, explore how to exclude hidden or filtered rows in your Google Sheets formulas. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're dealing with large datasets or trying to streamline your data analysis, this tutorial will show you the steps to ensure your calculations and references only include visible da...
Add Updated Date Stamps with your Checkbox in Google Sheets! (NOW Function)4:10Add Updated Date Stamps with your Checkbox in Google Sheets! (NOW Function)
Add Updated Date Stamps with your Checkbox in Google Sheets! (NOW Function)
มุมมอง 129วันที่ผ่านมา
In this video, you'll learn how to add updated date stamps with checkboxes in Google Sheets! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're tracking tasks, managing projects, or keeping tabs on any changes, this tutorial will help you automate date entries efficiently. I’ll guide you step-by-step on how to use Googl...
Google Sheets: Autofill you Columns with Numbers with this trick! (With Three Functions)3:32Google Sheets: Autofill you Columns with Numbers with this trick! (With Three Functions)
Google Sheets: Autofill you Columns with Numbers with this trick! (With Three Functions)
มุมมอง 902 วันที่ผ่านมา
In this video, learn the trick to autofill your columns with numbers in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Say goodbye to manual entry and hello to efficiency! Whether you're managing data, creating lists, or organizing information, this step-by-step guide will show you how to quickly populate your sheet...
Google Sheets: ArrayFormula or QuickFill, which is better? (Choose you Pick)3:00Google Sheets: ArrayFormula or QuickFill, which is better? (Choose you Pick)
Google Sheets: ArrayFormula or QuickFill, which is better? (Choose you Pick)
มุมมอง 9014 วันที่ผ่านมา
In this video, dive into the world of Google Sheets to explore two powerful features: ArrayFormula and QuickFill. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Which one is better for your data management needs? Let’sl compare their functionalities, efficiency, and ease of use, helping you determine the best tool for your spreads...
Google Sheets: Combine Data from Multiple Sheets with one Formula! (Consolidate Data)3:25Google Sheets: Combine Data from Multiple Sheets with one Formula! (Consolidate Data)
Google Sheets: Combine Data from Multiple Sheets with one Formula! (Consolidate Data)
มุมมอง 23914 วันที่ผ่านมา
In this video, learn how to combine data from multiple sheets in Google Sheets using just one formula! ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Whether you're managing a project, analyzing data, or organizing information, this tutorial simplifies the process of merging data from various sheets into a single, cohesive view. D...
How to Quickly Make an Attendance Tracker in Google Sheets (CountIF Function)3:24How to Quickly Make an Attendance Tracker in Google Sheets (CountIF Function)
How to Quickly Make an Attendance Tracker in Google Sheets (CountIF Function)
มุมมอง 12414 วันที่ผ่านมา
In this video, you'll learn how to quickly create an efficient attendance tracker in Google Sheets. ✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈 Perfect for teachers, event organizers, or team leaders, this step-by-step tutorial will guide you through the process of setting up a dynamic, easy-to-use attendance sheet. I'll cover ...
Create a Conditional Checkbox in Google Sheets (IF Function)4:03Create a Conditional Checkbox in Google Sheets (IF Function)
Create a Conditional Checkbox in Google Sheets (IF Function)
มุมมอง 12514 วันที่ผ่านมา
Create a Conditional Checkbox in Google Sheets (IF Function)
Adding Slicers in your Pivot Table in Google Sheets (Dynamic Filter)3:50Adding Slicers in your Pivot Table in Google Sheets (Dynamic Filter)
Adding Slicers in your Pivot Table in Google Sheets (Dynamic Filter)
มุมมอง 10914 วันที่ผ่านมา
Adding Slicers in your Pivot Table in Google Sheets (Dynamic Filter)
How to do a Search Filter in Google Sheets (Filter by Values)2:47How to do a Search Filter in Google Sheets (Filter by Values)
How to do a Search Filter in Google Sheets (Filter by Values)
มุมมอง 9314 วันที่ผ่านมา
How to do a Search Filter in Google Sheets (Filter by Values)
How to Remove Filter in Google Sheets (Clear Filter)1:18How to Remove Filter in Google Sheets (Clear Filter)
How to Remove Filter in Google Sheets (Clear Filter)
มุมมอง 8221 วันที่ผ่านมา
How to Remove Filter in Google Sheets (Clear Filter)
How to Filter Columns by Condition in Google Sheets (Filter Options)2:53How to Filter Columns by Condition in Google Sheets (Filter Options)
How to Filter Columns by Condition in Google Sheets (Filter Options)
มุมมอง 7121 วันที่ผ่านมา
How to Filter Columns by Condition in Google Sheets (Filter Options)
Insert Checkboxes based on Cell Values in Google Sheets (DATA Validation)3:44Insert Checkboxes based on Cell Values in Google Sheets (DATA Validation)
Insert Checkboxes based on Cell Values in Google Sheets (DATA Validation)
มุมมอง 7421 วันที่ผ่านมา
Insert Checkboxes based on Cell Values in Google Sheets (DATA Validation)
Count Values Without Using Formulas in Google Sheets (Insert Chart)4:02Count Values Without Using Formulas in Google Sheets (Insert Chart)
Count Values Without Using Formulas in Google Sheets (Insert Chart)
มุมมอง 6721 วันที่ผ่านมา
Count Values Without Using Formulas in Google Sheets (Insert Chart)
How to Use the Paste Special in Google Sheets (Paste as Plain Text)5:59How to Use the Paste Special in Google Sheets (Paste as Plain Text)
How to Use the Paste Special in Google Sheets (Paste as Plain Text)
มุมมอง 8421 วันที่ผ่านมา
How to Use the Paste Special in Google Sheets (Paste as Plain Text)
How to do Advanced Conditional Formatting in Google Sheets (INDIRECT FUNCTION)9:32How to do Advanced Conditional Formatting in Google Sheets (INDIRECT FUNCTION)
How to do Advanced Conditional Formatting in Google Sheets (INDIRECT FUNCTION)
มุมมอง 41421 วันที่ผ่านมา
How to do Advanced Conditional Formatting in Google Sheets (INDIRECT FUNCTION)
How to Use the INDIRECT Function in Google Sheets (Range to String)5:24How to Use the INDIRECT Function in Google Sheets (Range to String)
How to Use the INDIRECT Function in Google Sheets (Range to String)
มุมมอง 22928 วันที่ผ่านมา
How to Use the INDIRECT Function in Google Sheets (Range to String)
Use IF Function with Multiple Conditions in Google Sheets (AND Function)3:48Use IF Function with Multiple Conditions in Google Sheets (AND Function)
Use IF Function with Multiple Conditions in Google Sheets (AND Function)
มุมมอง 9928 วันที่ผ่านมา
Use IF Function with Multiple Conditions in Google Sheets (AND Function)
How to Use the IFS Function in Google Sheets (Multiple Conditions)3:42How to Use the IFS Function in Google Sheets (Multiple Conditions)
How to Use the IFS Function in Google Sheets (Multiple Conditions)
มุมมอง 11128 วันที่ผ่านมา
How to Use the IFS Function in Google Sheets (Multiple Conditions)
Create a Pivot Chart in Google Sheets (Column Chart)2:44Create a Pivot Chart in Google Sheets (Column Chart)
Create a Pivot Chart in Google Sheets (Column Chart)
มุมมอง 117หลายเดือนก่อน
Create a Pivot Chart in Google Sheets (Column Chart)
Add & Remove Data from Charts in Google Sheets (Chart Editor)3:03Add & Remove Data from Charts in Google Sheets (Chart Editor)
Add & Remove Data from Charts in Google Sheets (Chart Editor)
มุมมอง 88หลายเดือนก่อน
Add & Remove Data from Charts in Google Sheets (Chart Editor)
How to Use the REPLACE Function in Google Sheets (Old to New)2:49How to Use the REPLACE Function in Google Sheets (Old to New)
How to Use the REPLACE Function in Google Sheets (Old to New)
มุมมอง 179หลายเดือนก่อน
How to Use the REPLACE Function in Google Sheets (Old to New)

ความคิดเห็น

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 3 วันที่ผ่านมา

    Thank you

  • @TilakConrad
    @TilakConrad 3 วันที่ผ่านมา

    yet another superb tutorial - couldn't find the code though for onbarcode

    • @WorkflowWisdom
      @WorkflowWisdom 2 วันที่ผ่านมา

      You'll have to click on the video playing on the site that I gave, then you'll see the code in the description of that video. You can also just pause my video and copy the code that I highlighted. It will be the same code.

  • @praveenchawla6999
    @praveenchawla6999 4 วันที่ผ่านมา

    Nice. Clear and Short.

    • @WorkflowWisdom
      @WorkflowWisdom 3 วันที่ผ่านมา

      Glad it was helpful!

  • @Character-j1r
    @Character-j1r 4 วันที่ผ่านมา

    Thank you ❤ for your short videos focusing on the power of Google sheets. Can you also do an explanation of if you ever need a large data set with cells exceeding 10 billion cells on Googlesheets vs Excel? If you are working with data sets or are a data analyst / data scientist and can you still use Google sheets as a data scientist

    • @WorkflowWisdom
      @WorkflowWisdom 2 วันที่ผ่านมา

      I'll do my best to create a video for it in the future so stay tuned for that!

  • @Allen-L-Canada
    @Allen-L-Canada 4 วันที่ผ่านมา

    what would be a usage of this function?

    • @WorkflowWisdom
      @WorkflowWisdom 2 วันที่ผ่านมา

      I will be posting a video on how to create a dynamic calendar here on the channel to show you how I used the SEQUENCE function, so do look forward to that!

  • @krishnatate4765
    @krishnatate4765 5 วันที่ผ่านมา

    Thank you ma'am 😊

  • @MISComputerNET
    @MISComputerNET 6 วันที่ผ่านมา

    When and why would we need such a function in real life? Any examples you might have?

    • @WorkflowWisdom
      @WorkflowWisdom 2 วันที่ผ่านมา

      The CELL function gives you specific information about your cells. It's a great function to use when you're dealing with a large set of data and you want specifics about your cells. For example, when you want to know if your cell contains plain text, other values or just blank, the CELL Function will help you determine that with this formula: =CELL("Type",A1), if it returns an "l" you cell contains plain text, if it returns a "v" it contains other type of data like numbers and if it returns a "b" that means your cell is blank.

  • @Allen-L-Canada
    @Allen-L-Canada 6 วันที่ผ่านมา

    thanks. Can I do a line or bar, showing where a current stock price fall into the 52-week high and low, like they do in Yahoo Finance. for example, if the 52-week range is 20-60, current price is 40, then we show something like this: -------------•------------. The dot shows the current price. Thanks!

    • @WorkflowWisdom
      @WorkflowWisdom 2 วันที่ผ่านมา

      You can do a line chart but it won't be able to highlight the current price like it does in Yahoo Finance. Unfortunately, Google Sheets charts don't allow you to highlight a specific gridline in your chart.

  • @WorkflowWisdom
    @WorkflowWisdom 6 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 6 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 6 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 6 วันที่ผ่านมา

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

  • @Allen-L-Canada
    @Allen-L-Canada 6 วันที่ผ่านมา

    that was a cool function

    • @WorkflowWisdom
      @WorkflowWisdom 6 วันที่ผ่านมา

      Great to hear you liked it.

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 8 วันที่ผ่านมา

    Thanks ❤

    • @WorkflowWisdom
      @WorkflowWisdom 6 วันที่ผ่านมา

      You're welcome 😊

  • @isaak1904
    @isaak1904 8 วันที่ผ่านมา

    Love This

  • @IPlayIWA
    @IPlayIWA 9 วันที่ผ่านมา

    Awesome work. Thank you very much. I assume you can also do this in an importrange if you are dealing with more than one sheet.

    • @WorkflowWisdom
      @WorkflowWisdom 3 วันที่ผ่านมา

      Yes! You can absolutely do that. Just add the Function after the equal sign. For example, =SUM(IMPORTRANGE(spreadsheet_url, range_string)

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 10 วันที่ผ่านมา

    Thankyou

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 11 วันที่ผ่านมา

    Thank you so much... informative ❤

  • @isaak1904
    @isaak1904 11 วันที่ผ่านมา

    Thank you for sharing

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 13 วันที่ผ่านมา

    Excellent Thank you 😊

    • @WorkflowWisdom
      @WorkflowWisdom 10 วันที่ผ่านมา

      Glad it was helpful!

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 13 วันที่ผ่านมา

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

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 14 วันที่ผ่านมา

    Excellent Thank you ❤

  • @kirk1968
    @kirk1968 14 วันที่ผ่านมา

    Whoever creates your video thumbnails deserves a raise, they're always really good 😁 Interesting comparison, I have never thought to use ArrayFormula for situations like that. But now it's another option, thanks!

    • @WorkflowWisdom
      @WorkflowWisdom 13 วันที่ผ่านมา

      Glad you like them!

  • @MISComputerNET
    @MISComputerNET 15 วันที่ผ่านมา

    Thanks for the tutorial. As you mentioned, it might depend on the situation, I mostly prefer using arrays. Especially for big data sets having more than one thousand rows, arrays work just fine.

    • @WorkflowWisdom
      @WorkflowWisdom 13 วันที่ผ่านมา

      Thanks for sharing!

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 15 วันที่ผ่านมา

    Thankyou nice update

  • @AgendaBioBioCL
    @AgendaBioBioCL 16 วันที่ผ่านมา

    Can I let an empty column using Query?.... something like this =QUERY('Sheet 1!A1:E'; "SELECT A, B, " ", C, " ", D)

    • @WorkflowWisdom
      @WorkflowWisdom 10 วันที่ผ่านมา

      You can't add empty spaces in between columns selected in the Query Function. And you're formula in selecting specific columns should be separated by commas and not semicolons, ex: =QUERY('Quarter 1 2022'!A1:E8,"Select A,B"). Semicolons are only used in separating your ranges in an array.

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 18 วันที่ผ่านมา

    Thanks

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 20 วันที่ผ่านมา

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

  • @mohammedzabiulla4787
    @mohammedzabiulla4787 22 วันที่ผ่านมา

    Hi, i need to do the same for 750 rows. Any shortcut method ?

    • @WorkflowWisdom
      @WorkflowWisdom 16 วันที่ผ่านมา

      For now I haven't found a shortcut for this one, but once you've learned and followed the steps on the video, you'll be able to recreate these even with 750 rows.

    • @Zabiulla1
      @Zabiulla1 16 วันที่ผ่านมา

      Hi, Yes, I did the same I.e. I did it manually for all 750 rows. Thanks for this video!

    • @WorkflowWisdom
      @WorkflowWisdom 13 วันที่ผ่านมา

      @Zabiulla1: You are welcome.

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 22 วันที่ผ่านมา

    Thank you

  • @krishnatate4765
    @krishnatate4765 22 วันที่ผ่านมา

    Very helpful madam ❤

  • @wertyghjkl-fc3dx
    @wertyghjkl-fc3dx 22 วันที่ผ่านมา

    How about if your sheet2 and sheet3 were both 1stQuarter for 2 different years and you wanted to link them to the annual, with the intention of finding the annual average?

    • @WorkflowWisdom
      @WorkflowWisdom 20 วันที่ผ่านมา

      You can still link your sheets just make sure to rename your sheets with the proper year, for example, Sheet1 would be "2023 1st Quarter" then Sheet 2 would be "2024 1st Quarter." To get the annual average, just enter your formula at the end of your data set or table.

  • @kirk1968
    @kirk1968 23 วันที่ผ่านมา

    That is a very cool feature! I would not have known about it without this tutorial, many thanks 👏

  • @gagahguk
    @gagahguk 24 วันที่ผ่านมา

    can you combine =ARRAYFORMULA(SUMIFS(

    • @WorkflowWisdom
      @WorkflowWisdom 20 วันที่ผ่านมา

      Unfortunately, you cannot combine ARRAYFORMULA and SUMIFS in one formula.

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 24 วันที่ผ่านมา

    Thanks

  • @srikrishnanrengarajan6109
    @srikrishnanrengarajan6109 25 วันที่ผ่านมา

    Thanks

  • @WorkflowWisdom
    @WorkflowWisdom 26 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 26 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 26 วันที่ผ่านมา

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

  • @WorkflowWisdom
    @WorkflowWisdom 26 วันที่ผ่านมา

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