Welcome to Sheets Help. This channel offers comprehensive help for Google Sheets. Learn how to organize and analyze any spreadsheet with hundreds of functions and other advanced features.
Work faster in Google Sheets with our add-ons - College Compare, StaySorted, TIMEDIF, TripTally, and more at sheetshelp.com.
Hello, I am working on the small inventory management graph for my company where I move inventory between locations. I used Sumifs formula. I create transaction in one sheet and mark it ordered, it goes to Location 1 column in another sheet, then I mark it shipped it moves to Location 2 column, then I mark it received it moves to 3rd column. Which is perfect. But now I am stuck because I have to move full amount all the time. If I ordered 100 pc, I have to ship and receive 100pc but if I want to ship to different location only 20pc and location 1 will have 80pc left I can not do it. Could you please help me with that? Do you think it is possible to create it in Google sheets or it is too complicated?
Hi Elena. I wish I could provide a more in-depth answer, but I would have to log into your spreadsheet and discuss the process with you. Generally, basic inventory management is a good fit for spreadsheets but it's hard to say how you would get your specific use case to work. Best of luck.
Thank you. Yeah, there's not too much out there on these yet. If you look at the Excel documentation, it pretty different so you can't use that either.
can I somehow use two values for the key? For example: I have a table like in your example at 2:36, but I have two different people named Jim, one from South and one from North. I want to lookup for both their specialities by entering the name and region. How can I accomplish this?
Consider using the FILTER function instead. I made a video about comparing the two on my Prolific Oaktree channel. See if this helps: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zFo9H0Uw4i8.html
We're in a remote, multi-user set up with the sheet on a shared google drive. Does the add on need to be resident on all user computers to function on users computers?
I noticed it can only do approx 50 postcodes in a single run. And even after mutliple attempts of 3 times which is approx 150 searches it says limit has reached.
The connection to Google Maps has imitations that the add-on must abide by. One of them is a time-out limitation as you are describing. You will need to process your addresses in smaller batches.
It's a one-time fee, not per year. However, yeah, it's got to be worth it to you. I've priced the add-on to make sense for users saving hours by using it.
This can happen if you are using it with an XSLX file, have another Google account open in another browser tab, or are at an organization with add-on limitations. It can also be caused by configurations of shared drive permissions. Plz email me at adam@sheetshelp.com if you would like me to look at what you have going on.
You can probably skip forward to the part where the user pops out the side panel. The toggle button is there when you're running Google Sheets in a desktop browser.
Thank you for the awesome video! Why is the & needed when using dates as a criterion please? Can't we just write ">2/6/2022" instead of ">"&"2/6/2022"? When we use numbers for comparison, the & is not needed (e.g. ">12"), so I am bit confused why dates require it?
Thank you for this great video! What is a good use case for deleting a cell and shifting left/up? Is this something that is commonly used? I fail to see when I would want to do this.
I've been thinking about your question for a while now. Really, the only times I add/delete one cell within a table of data is to correct a problem. For example, if you added a row to a table then later realized that you missed the last column.
Can you do this with a range of sheets? I have new sheets added every time I have a new client and I want the new info to continually populate in my Summary sheet. THANKS!
I was so excited . . . this was going to be an IMMENSELY valuable tool. Yet I keep getting the same result after clicking the "Run" button: Add-on error Something went wrong when executing the add-on.
My email is bouncing back but here is my reply….The add-in needs pairs of addresses to work. In this case, you would need to copy the address in D58 into enough cells that each destination has a matching starting point. For example, you could copy the starting address into column I, and repeat it for each row. Then, the starting reference would be I2:I56. Please let me know if you have any other questions.
Is there a way to amend this concept to use for Conditional Formatting via custom formula of CountIF for if duplicates and do/don't contain specific test?
One thing to try is just to multiply the duration by one and see what you get. If it doesn't work or give a number in the thousands, you may have a time of day and not a duration.
Hi, great work! I feel like I'm way in over my head but I've self taught so many programs these last couple of years that I'm fast forwarding my aging in my fore head... What if the pivottable is not returning unique values?
Hey, after messaging you I actually thought the same thing and started scrolling through all the lines.. I’ve cleaned the data sheet and now it looks great 👍 Thanks for thorough videos, pivot tables really help as it doesn’t put the data sheet at risk when my colleagues need to get specific information from the data sheet. I wish there was an easier way to sort the pivot table with multiple rows. Also is there a way to search the whole pivot table?
@@loftahammarsvarvmarina2306 Use the "Order" drop down in the pivot table controls. That allows you to sort by a field. You can search it the traditional way with control F.
Hi- all spreadsheets had the same columns and headers name but can I do these where the 3 first columns of each tabs have the same headers but the other columns are not. Example tab 1,2,3 column A is country, b, state and c city but then each columns in each tab after column have headers with information and I want to combine all of this into one .
Actually just figured out how to do this, once the data is extracted into google sheets you can change the event details in calendar the back in google sheets you click the event then data extraction then to the right of sheets click refresh and manage. This is a game changer, been looking for a native solution without scripting for years.
You can always type them in. This video explains the different types of cell references. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-81KM2hnT9UQ.html
Great video! thanks. one comment though-you could get the same result just using the curly brackets. the usage of query is applicable when you choose ranges like A1:E that doesn't have an end for future data. and thus using the formula.... =QUERY({....;.....;.....}, "SELECT * WHERE Col1 IS NOT NULL")