Spreadsheetables

Spreadsheetables

Пікірлер

  • @saraschronicle
    @saraschronicleКүн бұрын

    thannk youu !!!

  • @StarrConsulting
    @StarrConsulting6 күн бұрын

    I’ve got another piece to add to your toolkit. I’ll drop it inside the fb group

  • @Ria0fd
    @Ria0fd12 күн бұрын

    Hello! Question, what if I only want a specific column to return or show in the filter tab? Thanks!

  • @spreadsheetables
    @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!

  • @tshay8946
    @tshay894620 күн бұрын

    Are these available in Tier 1?

  • @spreadsheetables
    @spreadsheetables15 күн бұрын

    @@tshay8946 no, but they are available in vip 🥰

  • @samanthastolz4383
    @samanthastolz438322 күн бұрын

    Is there a way to make it go the other way? So the finish line is on the right?

  • @yogeshshinde619
    @yogeshshinde61918 күн бұрын

    Yes

  • @markteachsellers
    @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!

  • @fireandice2301
    @fireandice230123 күн бұрын

    I'd like a .wav file to play based on certain responses in google sheets.

  • @andreiyserdniy
    @andreiyserdniy25 күн бұрын

    Can I ask you to share link to this SMART google sheets please

  • @user-ii5bi6lc1d
    @user-ii5bi6lc1d26 күн бұрын

    Thank you very much!

  • @Gene75135
    @Gene75135Ай бұрын

    thank you so much ! informative and straight to the point.

  • @CFerns100
    @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
    @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
    @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
    @beautifulplaces6328Ай бұрын

    @@spreadsheetables awwwee thank you so much for answering I was really stuck.

  • @spreadsheetables
    @spreadsheetablesАй бұрын

    @@beautifulplaces6328 you’re very welcome!

  • @sunnyempire
    @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
    @hancho_nachoАй бұрын

    I have concerns about how to use it. Could you please make a video for beginners?

  • @3ugeneS
    @3ugeneSАй бұрын

    Thank you. your saved life.

  • @sarahhill3773
    @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?

  • @spreadsheetables
    @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-oe6bu1ud3w
    @user-oe6bu1ud3w2 ай бұрын

    Very tricky to do that way.

  • @hendesemabedi
    @hendesemabedi2 ай бұрын

    Thank you. It is giving an idea....

  • @AndrewLouwrens
    @AndrewLouwrens2 ай бұрын

    Andrew

  • @SZF_LOGISTIK
    @SZF_LOGISTIK2 ай бұрын

    Dankeschön, das war sehr hilfreich!

  • @timz2917
    @timz29172 ай бұрын

    Make it excel compatible and you quadruple your market

  • @britttttttttttt
    @britttttttttttt2 ай бұрын

    That was so helpful! For those asking, its under Extentions > Apps Script

  • @johnrichmond007
    @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

  • @melihoksuz1344
    @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

  • @passiveincomepathways
    @passiveincomepathways3 ай бұрын

    47:50 Do you want it done perfectly, your way, or do you want to be able to turn your computer off? EXACTLY.

  • @passiveincomepathways
    @passiveincomepathways3 ай бұрын

    45:00 ouch LOL

  • @passiveincomepathways
    @passiveincomepathways3 ай бұрын

    39:00 "Paying experts to do things for you" - GOLD.

  • @passiveincomepathways
    @passiveincomepathways3 ай бұрын

    Thank youuuuu!!

  • @charalamposkounes5071
    @charalamposkounes50713 ай бұрын

    Nice sparkline tip

  • @sergeyrizen9113
    @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

  • @shaktidas6842
    @shaktidas68423 ай бұрын

    Thanks

  • @user-el7kw9yf2u
    @user-el7kw9yf2u3 ай бұрын

    Great! It helped me!

  • @KnottyFlyer
    @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.

  • @BoKAch26
    @BoKAch263 ай бұрын

    Can you post the Apps Script Code here ?

  • @thatNCgirl
    @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-Issu
    @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_LOGISTIK
    @SZF_LOGISTIK3 ай бұрын

    Danke, das war sehr Interessant und Hilfreich!!!!🤗

  • @BrianHeinLum
    @BrianHeinLum4 ай бұрын

    Nice, Can you post the Apps Script Code here ? 😊 Thanks

  • @itsjessicahomann
    @itsjessicahomann4 ай бұрын

    Melinda looks like my sister's in law twinny. both beautiful. all three of you.

  • @mikep6979
    @mikep69794 ай бұрын

    How do you prevent someone from copying it and selling it as their own?

  • @justine132
    @justine1324 ай бұрын

    This is mind blowing!! I just joined. I’m convinced. I love your accent too. Where are you from?

  • @spreadsheetables
    @spreadsheetables4 ай бұрын

    Aww thank you Justine! And welcome to the hub! I’m originally from Brazil 🇧🇷 but have been living in the US since 2009 😊

  • @rafaelborgesbatista2961
    @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-wj9hg
    @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?

  • @spreadsheetables
    @spreadsheetables4 ай бұрын

    Hi there! Did you remove the chart background?

  • @LeftYt-wj9hg
    @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?

  • @n7sheppie
    @n7sheppie4 ай бұрын

    I can't believe it was something so simple, haha. Thank you!!

  • @spreadsheetables
    @spreadsheetables4 ай бұрын

    I know right😅❤️

  • @billieoanh7788
    @billieoanh77884 ай бұрын

    Thank you for the great video ❤

  • @spreadsheetables
    @spreadsheetables4 ай бұрын

    Thank you for watching!❤️

  • @DianaMayeDesigns
    @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!

  • @spreadsheetables
    @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 😍

  • @richardrivera9864
    @richardrivera98644 ай бұрын

    Is the < src> still a valid function?

  • @ProfitPotentialConsulting
    @ProfitPotentialConsulting4 ай бұрын

    What are you using to record your videos? I love the format!

  • @spreadsheetables
    @spreadsheetables4 ай бұрын

    This video was recorded inside of Canva! But it started being glitchy, so we now use Loom (similar format)

  • @justin-made-it
    @justin-made-it5 ай бұрын

    36:31 Clipart Prompt Generator ⭐