Видео

It won't grab anything that you can't also get with a browser.

​@@SheetsHelpI don't understand, I would like to retrieve the titles of public RUclips videos

I don’t know if that would work

@SheetsHelp but I don't understand what you wanted to tell me in your first answer

@@chrisder1814 I thought you wanted to retrieve deleted information since you used the word "recover."

Glad you liked it!

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.

Thank you, glad you liked it.

Glad you like them!

Consider using the FILTER function instead. I made a video about comparing the two on my Prolific Oaktree channel. See if this helps: ruclips.net/video/zFo9H0Uw4i8/видео.html

Yes, the sorting only occurs when a user adds a row and they are running the add on.

You're welcome!

I have a paid Google account. Those show more options.

Thank you, I appreciate the feedback. It takes a lot of time to make these videos!

Make sure you give it permission to do the import.

Do you see the toggle in the lower right hand corner like it is in the video? If not, maybe you are using a mobile version of the browser?

This may help, not sure: ruclips.net/video/QBuME5VrrhM/видео.html

Thanks!

Try =COUNTIF(A:A,NOT("None"))

Glad it was helpful!

That's great. It appears to be better than the CHOOSE formula I used. I'll put this on my list of revisions and may change the video.

The easiest thing to do is copy formulas and paste them as values.

Well, your comment made my day!

Alright, glad you appreciated it!

You're welcome!

Thank you!

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.

@@SheetsHelp is there an alternative suggestion to handle larger batches?

No, it’s an inherent limitation of the add-on’s interaction with Maps. My users just run the addresses in the largest batches they can get away with.

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.

I'd keep it simple and try =WEEKNUM(A1)-4.

@@SheetsHelp 😅 thank you

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.

Hey there. This video walks through the process, let me know if you still have questions.

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.

You're welcome!

Thank you! Cheers!

You've found the right video. Maybe the web page would help you out too: sheetshelp.com/column-of-random-numbers/

This is the only explanation I've seen for the quirky syntax. I agree that it's awkward. exceljet.net/articles/excels-racon-functions

@@SheetsHelp Thank you, this is a great in depth article.

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.

@@SheetsHelp Thank you, this makes sense.

I’m glad you liked it!

Thanks! I'm getting to the time of year when I can make a lot more, so watch out!

I don't think so. That would be something you have to do with Apps Script.

@@SheetsHelp Thanks for letting me know!

I can help you out. Please connect with me at adam@sheetshelp.com .

@@SheetsHelp Thanks Adam. I'll send an email with the example and a screen shot.

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.

@@SheetsHelp It worked! It worked! Thanks Adam! So cool.

Try out this video, it's in the same vane of what you're asking about ruclips.net/video/CrwFQqxzQn8/видео.htmlfeature=shared

Thanks, I'm glad you liked it.

The add on needs a bit of space so we ask you to start at row 2 of below.

Thank you! @@SheetsHelp

You're welcome. I'm glad you enjoyed it.

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.

Most welcome

Making YT Shorts has MADE me keep them under one minute. I'm glad you liked it that way!

It’s possible you have spaces, different capitalization, punctuation that makes them different.

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.

What is the error?

I wouldn’t recommend it. You’ll have a hard time getting meaningful output.

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.

Yeah, the chips are dynamic so they’ll pick up changes. Sometimes it just takes a while.

You can always type them in. This video explains the different types of cell references. ruclips.net/video/81KM2hnT9UQ/видео.html

Thanks for the alternative. I am not clear on why the change though and referencing the curly braces. Both formulas are using curly braces.

in your example you could only use the curly brackets only@@SheetsHelp