Sheetgo
Sheetgo
  • 221
  • 2 101 335
IMPORTRANGE 2.0 and Filter by column
Welcome to January's product releases video, where we dive deep into the newest IMPORTRANGE 2.0 update and the new Filter by column data processor.
Sheetgo is the best alternative for Google's IMPORTRANGE function. Go to Sheetgo: app.sheetgo.com/ and test it out!
In this video we are covering:
1. IMPORTRANGE 2.0
2. Filter by column
3. Learn how to apply these in our process design workshop
Resgiter for the next workshop: www.sheetgo.com/automate-your-google-workspace/?
Go deeper by visiting our learn center:
👉 Explore all about Sheetgo features: app.sheetgo.com/learn
____________________________________________
How teams can apply these features:
Finance teams: Pull only relevant budget details for reporting.
Project managers: Reorder and refine key metrics for better dashboards.
Inventory managers: Select only stock levels, reorder points, or supplier
details from large datasets.
Manufacturing teams: Import production schedules, material usage, or quality control data without unnecessary columns.
HR teams: Share salary reports while keeping sensitive data private.
____________________________________________
Have any ideas or requests for tutorials? Leave a comment with your idea or request
____________________________________________
► If you need guidance, our experts can help you find the best plan for your team: www.sheetgo.com/contact-sales/
► Subscribe to Sheetgo's UA-cam channel: ua-cam.com/users/Sheetgo
Переглядів: 116

Відео

Product releases December 2024
Переглядів 163Місяць тому
Welcome to December's product releases video, where we dive deep into the newest features and enhancements brought to you by Sheetgo. Go to Sheetgo: app.sheetgo.com/ In this video we are covering: 1. 2024 wrap up 2. No branding in forms and dashboards 3. Enhanced mobile access Go deeper with these resources 👉 Missed the new UI launch? View it all here: ua-cam.com/video/IoBpkOKg5b4/v-deo.html LE...
Automate your Google Workspace - Purchase order management system
Переглядів 3162 місяці тому
In this hands-on workshop, the Sheetgo automation experts showcase how to automate a purchase order system-turning a manual process into a streamlined, error-free machine! 🚀 Using a real-world example, we’ll walk you through building a solution that simplifies purchasing, improves tracking, and ensures everyone stays on the same page. Go to Sheetgo: app.sheetgo.com/? ► Copy the purchase order s...
Product releases November 2024
Переглядів 1182 місяці тому
Welcome to November's product releases video, where we dive deep into the newest features and enhancements brought to you by Sheetgo. Learn how to use these features in our monthly automation workshops: www.sheetgo.com/automate-your-google-workspace/? In this video we are covering: 1. New UI for all users and UI new updates 2. CC & BCC for Gmail 3. Insert images on document generation 4. Autosa...
Automate your Google Workspace - University fund management and reporting workshop
Переглядів 6223 місяці тому
In this interactive workshop, the Sheetgo team demonstrates a real-world automation for university fund management, featuring a use case from the University of Alaska. Learn how to create an efficient system that automates reporting and improves transparency for donor fund distribution. Go to Sheetgo: app.sheetgo.com/? What’s Covered: 👉Designing a process for fund tracking and reporting 👉Creati...
Tell a story with your data using a Sheetgo Dashboard
Переглядів 2123 місяці тому
Tell a story with your data using a Sheetgo Dashboard
How to create a Sheetgo Form
Переглядів 2044 місяці тому
How to create a Sheetgo Form
How to filter by query
Переглядів 754 місяці тому
How to filter by query
How to filter by condition
Переглядів 854 місяці тому
How to filter by condition
How to split data using Sheetgo
Переглядів 1084 місяці тому
How to split data using Sheetgo
How to Merge Data
Переглядів 1174 місяці тому
How to Merge Data
What is a Sheetgo transfer?
Переглядів 1544 місяці тому
What is a Sheetgo transfer?
What is the Sheetgo workspace?
Переглядів 2154 місяці тому
What is the Sheetgo workspace?
What are sources and destinations?
Переглядів 2764 місяці тому
What are sources and destinations?
What is a Sheetgo Automation and how to create one
Переглядів 5924 місяці тому
What is a Sheetgo Automation and how to create one
Add automatic notifications to your Google Sheet inventory spreadsheet
Переглядів 4174 місяці тому
Add automatic notifications to your Google Sheet inventory spreadsheet
Barcode inventory system - best barcode for inventory management
Переглядів 5994 місяці тому
Barcode inventory system - best barcode for inventory management
The ultimate inventory spreadsheet - Create your inventory management system on Google Sheets
Переглядів 3,9 тис.4 місяці тому
The ultimate inventory spreadsheet - Create your inventory management system on Google Sheets
Introducing the new app bar - Go with the Workflow
Переглядів 2705 місяців тому
Introducing the new app bar - Go with the Workflow
Introducing the new Workspace - Go with the Workflow
Переглядів 3955 місяців тому
Introducing the new Workspace - Go with the Workflow
Introducing the new Workflow canvas - Go with the Workflow
Переглядів 5535 місяців тому
Introducing the new Workflow canvas - Go with the Workflow
Introducing the new Sheetgo - Go with the Workflow
Переглядів 1,6 тис.5 місяців тому
Introducing the new Sheetgo - Go with the Workflow
Get to know the Sheetgo add-ons
Переглядів 8 тис.6 місяців тому
Get to know the Sheetgo add-ons
How to use the LOOKUP function in Google Sheets
Переглядів 1,8 тис.6 місяців тому
How to use the LOOKUP function in Google Sheets
Product releases June 2024
Переглядів 3806 місяців тому
Product releases June 2024
Product releases May 2024
Переглядів 717 місяців тому
Product releases May 2024
Sheetgo Add-on for Google Sheets mail merge
Переглядів 4197 місяців тому
Sheetgo Add-on for Google Sheets mail merge
Product releases April 2024
Переглядів 2629 місяців тому
Product releases April 2024
Product releases March 2024
Переглядів 22810 місяців тому
Product releases March 2024
Product releases February 2024
Переглядів 23010 місяців тому
Product releases February 2024

КОМЕНТАРІ

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

    Amazing 😃

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

      Glad you enjoyed this update Mauricio!

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

    IS THIS 100% FREE?

    • @Sheetgo
      @Sheetgo 14 днів тому

      Hey there, thanks for reaching out to Sheetgo. This template is free to install and use with a scheduled automation trigger of up to once a day.

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

    Good productivity enhancer!

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

      Hey Vivek, glad yo know that Sheetgo is enhancing your productivity.

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

    Came across Sheetgo two days ago, I'm hooked implementing automations in the workplace now. Thanks for the great examples on UA-cam, it helps a lot!

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

    Thank you for this video I don't really get why it turned in a wrong result, and why sorting the values fixes the issue

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

      Hi there, gald you liked the video! LOOKUP assumes the data in the search_range is sorted in ascending order. If it is not, LOOKUP does not guarantee accurate results.

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

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

    I think am good to go! Working on a Database... Thanks

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

      Great to hear this! Let us know if you have any questions on the way

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

    Waaaaaaaaaaw it's cool, how about book value per share & financial ratios in google finance?

  • @alibennani-smires9347
    @alibennani-smires9347 Місяць тому

    merry xmas and happy new year

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

      Right back at you Ali!

  • @mike-yp1uk
    @mike-yp1uk Місяць тому

    Wow that's awesome

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

      Glad it was helpful!

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

    Is it free or sub based?

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

      Hi there! Sheetgo has a free user which allows you to install the template and run it manually. Here's more information about the different pricing plans: www.sheetgo.com/pricing/

  • @pinkshirt02
    @pinkshirt02 2 місяці тому

    The page you are working on is too blurry for me to read - even when I maximized. Help??

  • @hugsandthanks1460
    @hugsandthanks1460 2 місяці тому

    GREAT job

    • @Sheetgo
      @Sheetgo 2 місяці тому

      Thanks! I'm glad to see Sheetgo is helping you

  • @Munomedia
    @Munomedia 2 місяці тому

    Perfect 👍

    • @Sheetgo
      @Sheetgo 2 місяці тому

      Thank you! Glad to see you're enjoying Sheetgo

  • @estradalucy36
    @estradalucy36 2 місяці тому

    Can I add a column with the price? So we can also view $ on the overall screen?

    • @Sheetgo
      @Sheetgo 2 місяці тому

      Hi there! The template is developed in Google Sheets, providing you with the flexibility to add columns as you need to. We don not recommend this if you don't have expertise with formulas, since adding columns might break the template. If you want to learn how to create your own inventory system from scratch, you can watch this video: ua-cam.com/video/6B5F_ONqhaY/v-deo.html

  • @MichelleBlanco-z2x
    @MichelleBlanco-z2x 3 місяці тому

    Thank you for the simple, pleasant explanation with out a long prelude! It's working 🙂

  • @Rahulravindra660
    @Rahulravindra660 3 місяці тому

    It has only 9 days trial then need to pay to access

    • @Sheetgo
      @Sheetgo 3 місяці тому

      Hi there! We offer a 14-day free trial with a 7 day extension. Also, the merge feature is available under the free plan up to 10 files. If you are merging more than 10 files, we offer plans from as little as $22/month. If you have any other questions, please let me know.

  • @aavisheknandi9-carcosmos
    @aavisheknandi9-carcosmos 3 місяці тому

    ❤from India. I have been trying Sheetgo and it's been really lifesaver

    • @Sheetgo
      @Sheetgo 2 місяці тому

      Glad to know we help people automate their processes from all over the world! Hope to see you on the next workshop

  • @btc-vlogs6776
    @btc-vlogs6776 3 місяці тому

    Hey hi it's very informative but a small suggestion is-Can you wait for a while when you're moving to the next step as it is very hard to catch up with your mouse movement..

    • @Sheetgo
      @Sheetgo 3 місяці тому

      Hi there! Of course. Thanks for the suggestion. Also, if you have any other processes you would like us to automate, please submit it so we can create it.

  • @NoName-ie3yr
    @NoName-ie3yr 4 місяці тому

    Crap

  • @navsaridapcu8212
    @navsaridapcu8212 4 місяці тому

    and when update data next month than what

  • @Christian-xn4xm
    @Christian-xn4xm 4 місяці тому

    It does not seem like it is possible to do this any longer. It can only import files into separate tabs in one Sheet.

    • @Sheetgo
      @Sheetgo 4 місяці тому

      Hey there! You can merge multiple sheets by using the merge data processor. Here's updated documentation: blog.sheetgo.com/how-to-solve-with-sheetgo/how-to-merge-google-sheets/ If you need a demo, you can book via this url: sheetgo.com/demo

  • @ssadeepak
    @ssadeepak 4 місяці тому

    STOCK &INDICES FUTURE DATA IN GOOGLE SHEET

  • @Eng-nf4eo
    @Eng-nf4eo 4 місяці тому

    Can someone please tell me how can i translate to (kurdish sorane) i can’t find the shortcut 😢

    • @MWYNN-o6l
      @MWYNN-o6l 2 місяці тому

      I found this : The language code for Sorani Kurdish is ckb: • ISO 639-3: ckb • Glottolog: cent1972 Here are some other Kurdish language codes: • Kurmanji: kmr • Southern Kurdish: sdh • Laki: lki The general code for Kurdish is ku. However, Microsoft used ku for Central Kurdish and kmr for Northern Kurdish.

  • @melvinvidalrodriguezdelacr7697
    @melvinvidalrodriguezdelacr7697 5 місяців тому

    Entendia que esa era la solución pero la formula ImportRange hace lo mismo.

    • @Sheetgo
      @Sheetgo 5 місяців тому

      IMPORTRANGE es una gran formula, pero si queres hacer un sistema escalable, con IMPORTRANGE te vas a encontrar con errores eventualmente. Te dejo un blog sobre la diferencia entre Sheetgo e IMPORTRANGE: blog.sheetgo.com/google-sheets-formulas/importrange-vs-sheetgo/

  • @MoisheFriedman-x5j
    @MoisheFriedman-x5j 5 місяців тому

    Thank you for the amazing explanation. is what you described included in the free plan of sheetgo?

    • @Sheetgo
      @Sheetgo 5 місяців тому

      Hi there! Thanks for watching. Sheetgo forms are available under Sheetgo's free plan. Here's more information about our plans: www.sheetgo.com/pricing/

  • @Summersolstice1826
    @Summersolstice1826 5 місяців тому

    How to use importhtml to scrape data from a web with multiple pages?

  • @ubaidali1762
    @ubaidali1762 5 місяців тому

    Perfect, thank you

  • @Nature_explore_Mn
    @Nature_explore_Mn 6 місяців тому

    Nice, I understand ❤❤❤❤

  • @Summersolstice1826
    @Summersolstice1826 6 місяців тому

    Hello!👋 I'm studying how to scrape data from the website using MS Excel and Google Spreadsheet Functions. About the index, when we open the Inspect Element how do we identify the number of the table or list? I am new about this and i don't have enough knowledge on how to write the code, JavaScript or even how to read it properly. I hope I may receive a response from you.

  • @NamitaHiranandani
    @NamitaHiranandani 6 місяців тому

    I am not able to edit dates and format of time sheet as I want to add new tabs for remaining holidays and over time days

  • @NamitaHiranandani
    @NamitaHiranandani 6 місяців тому

    Is this free or payable? and how many employees can be added is there any limitation?

  • @AmbrosianAdventures
    @AmbrosianAdventures 6 місяців тому

    I followed your instructions. However, when I use the "Drag down option", the sequencing is off and I get back mostly "N/A" as the output. Is there a way to switch the sequencing so that it references the ticker symbol for all of the attributes"?

  • @ferozkibria9211
    @ferozkibria9211 6 місяців тому

    Excellent Solution

    • @Sheetgo
      @Sheetgo 6 місяців тому

      Thank you!

  • @Astro_Fizzix
    @Astro_Fizzix 6 місяців тому

    THIS VIDEO CONTAINS ERRORS! FIND OTHER UA-cam VIDEOS ON THIS TOPIC!! Please downvote to encourage this channel to remove or rework this video!!

    • @Sheetgo
      @Sheetgo 6 місяців тому

      Hi there, thank you so much for your feedback. We have an updated version of this video: ua-cam.com/video/cRvb8hDnmUk/v-deo.html We are constantly striving to provide new and quality content. If you have any requests, please share them so we can keep creating content that helps you bring life to your data!

  • @thomasindra1622
    @thomasindra1622 6 місяців тому

    NICE marketing product. Thank you

    • @Sheetgo
      @Sheetgo 6 місяців тому

      Than you for your feedback! We hope Sheetgo helps you save time to focus on what really matters

  • @brookbarock3794
    @brookbarock3794 6 місяців тому

    Don't try it...

    • @Poscolyo
      @Poscolyo 3 місяці тому

      The app is completely broken

  • @dodihidayata9435
    @dodihidayata9435 7 місяців тому

    great video, just one more about dividend. what is the funtion to track dividend ? thanks

  • @SantoshKumarSah-v1w
    @SantoshKumarSah-v1w 7 місяців тому

    HEY THANK YOU FOR YOUR VIDEO, HOW TO FIND YESTERDAY HIGH PRICE WITHOUT USING DATE?

  • @Urkrux
    @Urkrux 7 місяців тому

    Hello, it was really helpfull to understand it better. But I try currently to create an all time high overall. Is that possible too? My function is that: =INDEX(MAX(GOOGLEFINANCE(B3;"high";"01/01/1900";today()))) I just use that Date cause I have a little function where I can change the Ticker. Also I want that everything is changeing automaticly. Currently it works great. But my function is showing the Date and not the Price.. and When i Swap it it Shows all time the same date. xD Can you maybe help me with that? Thanks a lot :)

  • @relart6821
    @relart6821 7 місяців тому

    Very informative and easy to understand.

    • @Sheetgo
      @Sheetgo 7 місяців тому

      I am glad it was informative!

  • @jenniferrobertson8796
    @jenniferrobertson8796 8 місяців тому

    Would it be possible to have it create a pdf with each page using the Google Docs template? So for instance, once uses Google Sheets for journal entries and the PDF is supposed to be a readable journal with a page for each day. Thanks!

    • @Sheetgo
      @Sheetgo 7 місяців тому

      Hi Jennifer, Sheetgo creates a PDF like you saw on the video: by populating variable placeholders. So if you can create a template that will fill out with your spreadsheet data, then the PDF can be created that way! One PDF per row of data.

  • @brushfuse
    @brushfuse 8 місяців тому

    I would love if it were possible to add an extra field on the spreadsheet to add extra info, like the condition of the item. Is this possible?

    • @Sheetgo
      @Sheetgo 8 місяців тому

      Hi there, this is a template created to illustrate a use case that you can achieve with Sheetgo. The spreadsheet can be modified but you need to make sure not to brake any of the formula work that is in the sheets. We suggest you only add columns to the right. If you're not sure how to edit the template, you can check out Sheetgo for Supply chain where we have more advanced solutions as well as custom support: www.sheetgo.com/supply-chain/

    • @brushfuse
      @brushfuse 8 місяців тому

      @@Sheetgo Thank you for your reply!

  • @lauraVOlsen
    @lauraVOlsen 8 місяців тому

    =googlefinance("currency:usddkk") doesn't work on me here, don't know why. I have never being good at this Stof, waiting for AI help someday from google...:)

  • @AnotherDustSpec
    @AnotherDustSpec 8 місяців тому

    wtf, how do i get sunday , monday , tuesday

  • @ΦοιτητικέςΕργασίες
    @ΦοιτητικέςΕργασίες 8 місяців тому

    doesn't work for me, requires to add NYSE or NASDAQ in front of the ticker

  • @hugsandthanks1460
    @hugsandthanks1460 9 місяців тому

    Great! Looking forward to the May updates!

    • @Sheetgo
      @Sheetgo 9 місяців тому

      Lots to cover on the next one!