You are doing a great job sirji

You have such great a way to teach that it is so easy to understand. Thanks! I was wondering, could you make a video on Materialize CSS? You went into it in your 14-part series on web apps about 4 years ago and it was great. Thank you!!

Always solid gold. I did not know I could link to specific tabs. That will save a lot of time.

@Allen-L-Canada

Жыл бұрын

I wonder how does this feature help you. Could you give some examples?

@richardthemagician8991

Жыл бұрын

@Allen Lee I didn't know I could link directly to a spreadsheet tab. That's very helpful with my organization. I run my entire business through Google Docs and Google Sheets. Which means I have a lot of them. I have one master spreadsheet with links to all my other sheets. Think of it like having a homepage so I can navigate easily and quickly to the sheets I need. The issue I was having was whenever I would open the link, it would take me to whatever's have I was on last in that sheet. Sometimes, the tab it opens 2 is all the way to the right, which is just a mild inconvenience. Add that up with other mild inconveniences, and it becomes a big hassle. And sometimes I need to share sheet with a client but they only need to see a specific tab. This saves the trouble of having to instruct them to find the tab that pertains to them. And in general, this KZreadr creates fantastic, easy-to-follow tutorials. So I just wanted to give him a nice compliment on top of saying how useful this one was to me.

@Allen-L-Canada

Жыл бұрын

@@richardthemagician8991 thanks for sharing!

@Allen-L-Canada

Жыл бұрын

@@richardthemagician8991 Inspired by your idea, I am adding a "Menu" tab as my first tab in my frequently used Google Sheets. Here I build a navigation menu with tab names (or descriptions), and then insert links for those names. This way I can navigate my 40 some tabs in the spreadsheet much easier.

@ExcelGoogleSheets

Жыл бұрын

@richardthemagician8991 Thank you!

É o melhor canal entre todos para aprender sobre Google Sheets.

You are always rock around the developers and trainers

@ExcelGoogleSheets

Жыл бұрын

👍

This video was very helpful. Thank you sir

You are a GENIUS Thank You!

Thank You, I'll subscribe

Awesome 👍

@ExcelGoogleSheets

Жыл бұрын

👍

I love all your tutorials, thank you so much. You teach wonderfully. The "problem" that I have found with the hyperlink function is that if I use the Query function to filter data in another sheet, the links stop working. Only the label text appears, as plain text.

Excellent Lecture!

@ExcelGoogleSheets

Жыл бұрын

👍

Thank you for this great video. In your first example where you created an external link, is there a way to then have that link appear in a separate field? At the 1:00 mark, you create the field that says "Click Here" and it has a link but that link isn't visible. I want to be able to show the link in G2 without having to retype the entire link. Possible?

Muito bom seus vídeos obrigado por se esforçar gastar o seu tempo para trazer conhecimentos sou do Brasil e gosto

@ExcelGoogleSheets

Жыл бұрын

👍

Hello First, thank you for your ideas, which have benefited me a lot

@ExcelGoogleSheets

Жыл бұрын

👍

How to change the default link color for all links in a Google Sheet? I've tried other guides but they didn't work for me. I ask since I've manually colored many links in a file and I'd rather not anymore. Thankee!

Thanks a lot for all the knowledge over this time. Ps: Could you teach us how to clear a cell when filling another one? E.g., if you fill the cell "A1", then "B3" will be erased and vice-versa.

video idea: new google sheets functions in 2023 ToRow, ToCol, ChooseRows, ChooseCols, WrapRows, WrapCols, VStack, HStack, MarginOfError, EpochToDate, Let. (I know some of them like Let is already covered in your previous videos)

Thanks for all the helpul tutorials! I vaugly remember you showing how to define a function in a way so that it doesn't show up as an option on the trigger menu. (this function was only to be used by other functions). Can you remind me how that's done? I know this question is unrelated to this video but I'm not sure where else I can ask it. Thanks again!

@ExcelGoogleSheets

Жыл бұрын

Add underscore after function name and that's it. function tryme_(){ return null }

@yehudagoldberg8577

Жыл бұрын

@@ExcelGoogleSheets Thank you!

I have questions for you about google app script at the same different people using I want live update like google sheet. Is it possible ?.

But what about when you sort them? How do you automate the links to update?

Wonderful! 👍 How do I import/link Spot Prices for metals, Sliver, Gold, etc.? Tia!😊

It would be great if Google Sheets could offer a way to link files together, just like Power Pivot does. With this feature, users would be able to easily combine data from multiple sheets, making it easier to build complex reports and gain insights from their data.

@richardthemagician8991

Жыл бұрын

I'm curious. What do you mean by link files together? I believe you can already do exactly what you described with Google Sheets. I combine data from multiple sheets all the time to create complex record-keeping.

@Heliuage

Жыл бұрын

you can use function importrange

@ExcelGoogleSheets

Жыл бұрын

Google's alternatives are Google Looker Studio and Big Query. Google Looker Studio is Power Pivot, Big Query is Power Query.

@LotfyKozman

Жыл бұрын

@@richardthemagician8991 Link data completely differ than importing sheets or ranges.

@richardthemagician8991

Жыл бұрын

@@LotfyKozman I guess I'm fuzzy on the lingo. What does "link data" mean?

This was a great video but the only thing it didn't show is how do you point to different parts of the sheet not just a range. I couldn't find the command

What would be some practical usages of internal links?

@Heliuage

Жыл бұрын

for example in a1 you can add link moving you to the first not empty row (dynamically) in column a, row a1 is locked since it usually has titles of columns very handy if you have a big sheet

Please when are you going to continue showing us more examples of LET() LAMBDA() REDUCE() MAP() etc. working all together. Thanks!

Teacher...as always, Good Information - Very Well Presented! As a Side Note... the Simple Formula I started out designing has turned into a Monster and will not work as presented in your Invoice Tutorial!?!?

@ExcelGoogleSheets

Жыл бұрын

Hard to say without seeing an actual example/

@Electric-Bob

Жыл бұрын

@@ExcelGoogleSheets Teacher... what is the Best Way to do that?

is there a way to highlite 10 links and automatically import them into a google sheet, thanks for the video : )

Thanks, as always, for your videos!! I'm having trouble creating a link on a cell that is the result of a formula. I want the result to be the link to a tab/cell. Is this not possible? Thanks.

@markuswinter-cdps3008

11 ай бұрын

What would be the Google Sheets equivalent of this Excel formula: =IF(J2=0,"",HYPERLINK("#SPCodes!A"&MATCH(J2,SPCodes!$A:$A,0),J2))? I can't make it work in Sheets.

@markuswinter-cdps3008

11 ай бұрын

Disregard. Figured it out.

Hi 👋 I have master sheet with first name and last name data... I want to create another sheet and i wish when I put last name it's automatically get full name. Please guide what I do.....

@ExcelGoogleSheets

Жыл бұрын

kzread.info/dash/bejne/nahs0Lezqa7QXaQ.html kzread.info/dash/bejne/nYai0NanqbfNdrg.html

👍🏻 Great video, but very frustrating to see how much is missing from Google Sheets for Android!

@ExcelGoogleSheets

Жыл бұрын

I don't think that going to change much until they figure out a way to monetize those Android users.

Secondly, I hope you can help me in print a page in the Google Sheet using script edittor and thank you

@ExcelGoogleSheets

Жыл бұрын

The only way to print with script is to use some third party API that allows to print on your printer. You won't be able to replicate clicking on the print button.

@gelanikl8825

Жыл бұрын

@@ExcelGoogleSheets okay Can you please upload a video for us in the way of your smart ideas that explains the process of using the script editor in printing, with the addition of some useful ideas that always fascinate us with them, thank you

@gelanikl8825

Жыл бұрын

Hello I apologize for the inconvenience, but I hope you can help me with what you mentioned about printing via the API Because as you know, the person with experience surrounds you with many benefits when designing something unlike the novice Thank you for your kind review of this article

Could I make a link to point to a certain Tab of another Google Sheet?

@ExcelGoogleSheets

Жыл бұрын

Yes. Copy the link the same way I did by the end of this video and use that as a link in your other sheet.

@Allen-L-Canada

Жыл бұрын

@@ExcelGoogleSheets thanks.

@Allen-L-Canada

Жыл бұрын

@@ExcelGoogleSheets Also, I found that I can't insert a cell with a number in it, only date value or text value can be inserted with a link. How do I get around that? I am trying to do it so when I click the cell with number, it tasks me to the where the number comes from.

@ExcelGoogleSheets

Жыл бұрын

Use HYPERLINK function. Although technically it will still be text.

@Allen-L-Canada

Жыл бұрын

But the cell already have a numeric value in it. I can’t replace it with a hyperlink formula. For example I have a value of 0.08 in the cell. I want to be able to click it and jump to the external sheet’s tab, from where I got the value @@ExcelGoogleSheets