I’ve got another piece to add to your toolkit. I’ll drop it inside the fb group
@Ria0fd12 күн бұрын
Hello! Question, what if I only want a specific column to return or show in the filter tab? Thanks!
@spreadsheetables12 күн бұрын
Hi there! Great question! In that case you’ll only select the column you want to display in the results. So for example, instead of =filter(A2:E…., you will use =filter(A2:A….. hope that helps!
@tshay894620 күн бұрын
Are these available in Tier 1?
@spreadsheetables15 күн бұрын
@@tshay8946 no, but they are available in vip 🥰
@samanthastolz438322 күн бұрын
Is there a way to make it go the other way? So the finish line is on the right?
@yogeshshinde61918 күн бұрын
Yes
@markteachsellers23 күн бұрын
Hi, I also make spreadsheets on my channel but for e-commerce so it's good to see a fellow spreadsheet person with a channel. Anyway, I've never used the media features of Google sheets so thanks for the video!
@fireandice230123 күн бұрын
I'd like a .wav file to play based on certain responses in google sheets.
@andreiyserdniy25 күн бұрын
Can I ask you to share link to this SMART google sheets please
@user-ii5bi6lc1d26 күн бұрын
Thank you very much!
@Gene75135Ай бұрын
thank you so much ! informative and straight to the point.
@CFerns100Ай бұрын
I need to know how to record the "edited" date & time of a cells in various rows , in the same column. Can you help
@beautifulplaces6328Ай бұрын
Hoping someone will read this how do i make a mock up for a Google sheet template, i have tried saving mine in jpg so that i create mock up in canva but am not able to, do i screenshot or what do i do? I need help
@spreadsheetablesАй бұрын
Hi there! Yes, that’s correct! You will screenshot the portion of your spreadsheet you want to display and drop that into your Canva mockup 😊
@beautifulplaces6328Ай бұрын
@@spreadsheetables awwwee thank you so much for answering I was really stuck.
@spreadsheetablesАй бұрын
@@beautifulplaces6328 you’re very welcome!
@sunnyempireАй бұрын
Great to tutorial. Much appreciated. Although is there a way to password lock (no view) the do not edit sheet? In the case the formula is propretary?
@hancho_nachoАй бұрын
I have concerns about how to use it. Could you please make a video for beginners?
@3ugeneSАй бұрын
Thank you. your saved life.
@sarahhill37732 ай бұрын
Love using drawings for script buttons! Question… every once in a while when I open my spreadsheet, my buttons have moved slightly. Is there some way to keep this from happening?
@spreadsheetables2 ай бұрын
Ohh yeas, that’s a pain! only quick fix is to click on a different tab and then back into the main tab where the button is. Other than that I have no other trick to prevent it from moving. Happens to images as well 😩
@user-oe6bu1ud3w2 ай бұрын
Very tricky to do that way.
@hendesemabedi2 ай бұрын
Thank you. It is giving an idea....
@AndrewLouwrens2 ай бұрын
Andrew
@SZF_LOGISTIK2 ай бұрын
Dankeschön, das war sehr hilfreich!
@timz29172 ай бұрын
Make it excel compatible and you quadruple your market
@britttttttttttt2 ай бұрын
That was so helpful! For those asking, its under Extentions > Apps Script
@johnrichmond0072 ай бұрын
I have a google drive nested folder structure i want to package with google sheets in specific folders, docs and pdf's in others. how would you think to package this all into a digital product to sell in 1 click? bonus if you know how to add a looker studio dashboard to that product. :x
@melihoksuz13442 ай бұрын
I did everything as shown but when clickedit says we are sotty but there is something wring with the file. I tried with all formats, mp4, mp3, m4a so I don't know what might be wrong. I tried with not changing the link to preview as well but both didn't work
@passiveincomepathways3 ай бұрын
47:50 Do you want it done perfectly, your way, or do you want to be able to turn your computer off? EXACTLY.
@passiveincomepathways3 ай бұрын
45:00 ouch LOL
@passiveincomepathways3 ай бұрын
39:00 "Paying experts to do things for you" - GOLD.
@passiveincomepathways3 ай бұрын
Thank youuuuu!!
@charalamposkounes50713 ай бұрын
Nice sparkline tip
@sergeyrizen91133 ай бұрын
Okay, that's interesting. But for most of the watchers, it's not clearly understandable how to put this script to work. It's not enough to copy-paste it. Could you please show us how to do that? Many thjanks
@shaktidas68423 ай бұрын
Thanks
@user-el7kw9yf2u3 ай бұрын
Great! It helped me!
@KnottyFlyer3 ай бұрын
I found this video very helpful. Thank you. Now, can you help me turn off and on "auto recalculate on edit". I want to be able to recalculate only when I enter CRTL-R. Thanks.
@BoKAch263 ай бұрын
Can you post the Apps Script Code here ?
@thatNCgirl3 ай бұрын
Could you post the script? This is exactly what I've been looking for but it's really hard to read your script. Thanks!!
@Pappa-Issu3 ай бұрын
Thanks! Very nice! Is it possible to get autoplay in "Module", so it will start with just clicking your orange Play media-button? Is it possible to decide in which column and row that the "module" will pop up?
@SZF_LOGISTIK3 ай бұрын
Danke, das war sehr Interessant und Hilfreich!!!!🤗
@BrianHeinLum4 ай бұрын
Nice, Can you post the Apps Script Code here ? 😊 Thanks
@itsjessicahomann4 ай бұрын
Melinda looks like my sister's in law twinny. both beautiful. all three of you.
@mikep69794 ай бұрын
How do you prevent someone from copying it and selling it as their own?
@justine1324 ай бұрын
This is mind blowing!! I just joined. I’m convinced. I love your accent too. Where are you from?
@spreadsheetables4 ай бұрын
Aww thank you Justine! And welcome to the hub! I’m originally from Brazil 🇧🇷 but have been living in the US since 2009 😊
@rafaelborgesbatista29613 ай бұрын
@@spreadsheetablesI knew it! It was king hard, but I thought: “the accent.. it seems to have a little of Brazilian in it, but I was not sure”.. congrats!! Awesome content, and beautiful accent!
@LeftYt-wj9hg4 ай бұрын
Great video. However, in the android version of Google sheets the value in the center of the donut chart chart is not shown. I double-checked my chart editor settings and everything was correct. Is this happening to anyone else?
@spreadsheetables4 ай бұрын
Hi there! Did you remove the chart background?
@LeftYt-wj9hg4 ай бұрын
@@spreadsheetables Hi, yes, I did. In the web version everything works fine, unlike in android Google sheets app. It could be a bug within the app, I'm not sure. Does it work for you?
@n7sheppie4 ай бұрын
I can't believe it was something so simple, haha. Thank you!!
@spreadsheetables4 ай бұрын
I know right😅❤️
@billieoanh77884 ай бұрын
Thank you for the great video ❤
@spreadsheetables4 ай бұрын
Thank you for watching!❤️
@DianaMayeDesigns4 ай бұрын
I stayed home and totally forgot about St Patty's Day. haha Ty for a great video. I'm looking forward to doing one of my own!
@spreadsheetables4 ай бұрын
Awesome! Once you create your own dashboard feel free to share it with us in the FB group! We’d love to see your work 😍
@richardrivera98644 ай бұрын
Is the < src> still a valid function?
@ProfitPotentialConsulting4 ай бұрын
What are you using to record your videos? I love the format!
@spreadsheetables4 ай бұрын
This video was recorded inside of Canva! But it started being glitchy, so we now use Loom (similar format)
Пікірлер
thannk youu !!!
I’ve got another piece to add to your toolkit. I’ll drop it inside the fb group
Hello! Question, what if I only want a specific column to return or show in the filter tab? Thanks!
Hi there! Great question! In that case you’ll only select the column you want to display in the results. So for example, instead of =filter(A2:E…., you will use =filter(A2:A….. hope that helps!
Are these available in Tier 1?
@@tshay8946 no, but they are available in vip 🥰
Is there a way to make it go the other way? So the finish line is on the right?
Yes
Hi, I also make spreadsheets on my channel but for e-commerce so it's good to see a fellow spreadsheet person with a channel. Anyway, I've never used the media features of Google sheets so thanks for the video!
I'd like a .wav file to play based on certain responses in google sheets.
Can I ask you to share link to this SMART google sheets please
Thank you very much!
thank you so much ! informative and straight to the point.
I need to know how to record the "edited" date & time of a cells in various rows , in the same column. Can you help
Hoping someone will read this how do i make a mock up for a Google sheet template, i have tried saving mine in jpg so that i create mock up in canva but am not able to, do i screenshot or what do i do? I need help
Hi there! Yes, that’s correct! You will screenshot the portion of your spreadsheet you want to display and drop that into your Canva mockup 😊
@@spreadsheetables awwwee thank you so much for answering I was really stuck.
@@beautifulplaces6328 you’re very welcome!
Great to tutorial. Much appreciated. Although is there a way to password lock (no view) the do not edit sheet? In the case the formula is propretary?
I have concerns about how to use it. Could you please make a video for beginners?
Thank you. your saved life.
Love using drawings for script buttons! Question… every once in a while when I open my spreadsheet, my buttons have moved slightly. Is there some way to keep this from happening?
Ohh yeas, that’s a pain! only quick fix is to click on a different tab and then back into the main tab where the button is. Other than that I have no other trick to prevent it from moving. Happens to images as well 😩
Very tricky to do that way.
Thank you. It is giving an idea....
Andrew
Dankeschön, das war sehr hilfreich!
Make it excel compatible and you quadruple your market
That was so helpful! For those asking, its under Extentions > Apps Script
I have a google drive nested folder structure i want to package with google sheets in specific folders, docs and pdf's in others. how would you think to package this all into a digital product to sell in 1 click? bonus if you know how to add a looker studio dashboard to that product. :x
I did everything as shown but when clickedit says we are sotty but there is something wring with the file. I tried with all formats, mp4, mp3, m4a so I don't know what might be wrong. I tried with not changing the link to preview as well but both didn't work
47:50 Do you want it done perfectly, your way, or do you want to be able to turn your computer off? EXACTLY.
45:00 ouch LOL
39:00 "Paying experts to do things for you" - GOLD.
Thank youuuuu!!
Nice sparkline tip
Okay, that's interesting. But for most of the watchers, it's not clearly understandable how to put this script to work. It's not enough to copy-paste it. Could you please show us how to do that? Many thjanks
Thanks
Great! It helped me!
I found this video very helpful. Thank you. Now, can you help me turn off and on "auto recalculate on edit". I want to be able to recalculate only when I enter CRTL-R. Thanks.
Can you post the Apps Script Code here ?
Could you post the script? This is exactly what I've been looking for but it's really hard to read your script. Thanks!!
Thanks! Very nice! Is it possible to get autoplay in "Module", so it will start with just clicking your orange Play media-button? Is it possible to decide in which column and row that the "module" will pop up?
Danke, das war sehr Interessant und Hilfreich!!!!🤗
Nice, Can you post the Apps Script Code here ? 😊 Thanks
Melinda looks like my sister's in law twinny. both beautiful. all three of you.
How do you prevent someone from copying it and selling it as their own?
This is mind blowing!! I just joined. I’m convinced. I love your accent too. Where are you from?
Aww thank you Justine! And welcome to the hub! I’m originally from Brazil 🇧🇷 but have been living in the US since 2009 😊
@@spreadsheetablesI knew it! It was king hard, but I thought: “the accent.. it seems to have a little of Brazilian in it, but I was not sure”.. congrats!! Awesome content, and beautiful accent!
Great video. However, in the android version of Google sheets the value in the center of the donut chart chart is not shown. I double-checked my chart editor settings and everything was correct. Is this happening to anyone else?
Hi there! Did you remove the chart background?
@@spreadsheetables Hi, yes, I did. In the web version everything works fine, unlike in android Google sheets app. It could be a bug within the app, I'm not sure. Does it work for you?
I can't believe it was something so simple, haha. Thank you!!
I know right😅❤️
Thank you for the great video ❤
Thank you for watching!❤️
I stayed home and totally forgot about St Patty's Day. haha Ty for a great video. I'm looking forward to doing one of my own!
Awesome! Once you create your own dashboard feel free to share it with us in the FB group! We’d love to see your work 😍
Is the < src> still a valid function?
What are you using to record your videos? I love the format!
This video was recorded inside of Canva! But it started being glitchy, so we now use Loom (similar format)
36:31 Clipart Prompt Generator ⭐