How can I use a open and closed drop down to lock the contents of the adjancet cells.i want this open and close to work independently in every row
@FatmazohraMekaidechКүн бұрын
How can they be applied in appsheets
@allanaguilar15142 күн бұрын
Can you make a video using the days360 formula??
@ProlificOaktree6 сағат бұрын
It's linked at the bottom of the video, but here it is! kzbin.info/www/bejne/jGPbZHqoaN2Emck
@shylahh1383 күн бұрын
This was incredibly helpful, thank you kindly!
@tharindu51283 күн бұрын
Thank You very much Sir
@mangohouses4 күн бұрын
what about if you have more numbers than you can highlight at once? how do I do that?
@ProlificOaktree3 күн бұрын
You can type the range in manually or refer to it by its header.
@praveen56994 күн бұрын
I couldn't find the down arrow you clicked on the upper right corner next to the google drive button. I have to download 200 files manually. This is boring in Gmail
@jamesk000000014 күн бұрын
Thank you so much!
@ProlificOaktree3 күн бұрын
You're welcome. I hope it works well for you.
@harishkarthik43595 күн бұрын
Thanks, man!
@ProlificOaktree3 күн бұрын
No problem!
@Mangos686 күн бұрын
I used sum and mainly w columns , however the answer was not showing only the function? Pls how do you fix ? It's driving me crazy Also when I tried again it summed incorrectly and total was incorrect ?
@ProlificOaktree3 күн бұрын
Make sure your numbers are valid. Some may have spaces, commas, etc. Try the ISNUMBER function to check.
@TC3Dgraphicdesign6 күн бұрын
I bought Gemini Advanced 1.5 Pro but that icon does not appear in Google Sheets, how can I activate it?
@ProlificOaktree3 күн бұрын
Look around in the admin settings.
@live2teach457 күн бұрын
How would you do it if you just wanted to add 3 months, 6 months.. in advance?
@andrewsdelahoz52487 күн бұрын
Huge thank you for this video and I appreciate you made it very short and simple
@ProlificOaktree3 күн бұрын
Glad you liked it!
@siddharthjoshi68118 күн бұрын
Very Helpful video. Wanted to ask, how to use slicer to change charts when charts are copied to new sheets from the pivot table sheet.
@madisonpalomo647012 күн бұрын
This was helpful. Thank you!!
@ProlificOaktree3 күн бұрын
Glad it was helpful!
@rabidcabbage723016 күн бұрын
👍
@ProlificOaktree3 күн бұрын
🔥
@everettduncan754316 күн бұрын
Neither of these three situations seems to describe mine...when I try to divide the values in two cells, neither of them having a space, I get a #VALUE! error; my equation was: =DIVIDE(G43:G337, H2). The first range is a single cell that used a SUM function adding up the range
@ProlificOaktree3 күн бұрын
You can't use a range with DIVIDE. It doesn't know how you want to aggregate the range.
@MfonabasiAkpan-d1g17 күн бұрын
The shortest, easiest and most useful KZbin video I’ve ever watched
@ProlificOaktree17 күн бұрын
Glad you liked it! I'm still trying to do it that way.
@gracephoebea19 күн бұрын
This saved me. Thank you!
@ProlificOaktree17 күн бұрын
Glad it helped!
@shinylauj547320 күн бұрын
How do you set columns page numbers?
@sngs956520 күн бұрын
Thank you, Sir!
@ProlificOaktree20 күн бұрын
You are welcome!
@Mike-eh2tu21 күн бұрын
Very useful. How do I round 0.2578 down to 0.25? If I round down using the round down function 0.25 I get 0
@ProlificOaktree20 күн бұрын
=ROUNDDOWN(.2578, 2)
@Mike-eh2tu20 күн бұрын
@ thank you
@AnnieBleich23 күн бұрын
So helpful thank you
@ProlificOaktree20 күн бұрын
Glad it was helpful!
@jchaac25 күн бұрын
So, short answer… it isn't ready at all
@ProlificOaktree20 күн бұрын
Yeah, pretty much!
@KimLe-s1f25 күн бұрын
You just saved me 15 minutes. Thank you!
@ProlificOaktree20 күн бұрын
Glad I could help!
@jiteshsonar559125 күн бұрын
Excellent ! Thank you very much sir
@ProlificOaktree20 күн бұрын
Any time!
@DjSharma-o8c25 күн бұрын
useful
@ProlificOaktree20 күн бұрын
Glad to hear that
@RobKieranz26 күн бұрын
Grouping is an awful feature. Confusing as hell. Everything about it. Has been the root cause of a significant amount of very unneeded stress and problems whist trying to gather emails for a courtcase. Hard to explain fully, but it played a major role in making me miss some very important ones until last night, when I finally turned it off and could see properly and clearly! How I wish I had known/thought to turn it off a long time ago. Thank you.
@ProlificOaktree20 күн бұрын
Oh boy, that's pretty much what my wife said which is what prompted me to make this video!
@eunjae042126 күн бұрын
thank you i love you
@ProlificOaktree20 күн бұрын
Love you too;)
@MarvindMartian-sm8px28 күн бұрын
how to make an automatic border line?
@ProlificOaktree20 күн бұрын
Not possible with conditional formatting.
@mariahuby415029 күн бұрын
Thanks 😊
@ProlificOaktree20 күн бұрын
Welcome 😊
@estefaniii805229 күн бұрын
You earned my subscribe THANK YOUUU
@ProlificOaktree20 күн бұрын
Great to have you along!
@OliverWieheАй бұрын
This is soooo helpful - OMG i'm going to be mail merging EVERYTHING! Thx for the help "prolific oak" - love the content!
@ProlificOaktreeАй бұрын
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
@lizardgamertv8195Ай бұрын
POV: you’re tistic or Down syndrome like me
@danielnelson3136Ай бұрын
Seriously? Not a single video critiquing Gemini? Like using Gemini apparently makes you smarter and more productive, but before using it I was a dumb friendly psychopath, and after I'm still a dumb friendly psychopath, like my IQ points is still 100 before or after is what gives? And more productive? Sure but more productive messing around with schedules!😂😂
@ProlificOaktree29 күн бұрын
Wait, doesn’t mine count as a critique?
@DanielstrattonNZАй бұрын
any idea how to replicate the double click for sheets on mobile?
@ProlificOaktreeАй бұрын
No, I can't stand using it on mobile!
@nidiaymedinapaz2833Ай бұрын
Sir you are a life saver. It took some time and some trial and error but your video had everything I needed to know to make this feature work for me and this is going to save myself and my team a lot of time and a lot of stress.
@ProlificOaktreeАй бұрын
Glad to hear it helped you out!
@paraggupta7553Ай бұрын
How to hide some sections for some users while open to other users?
@ProlificOaktreeАй бұрын
You can't hide by range.
@missandramylezАй бұрын
lin"ltbnmk
@jodaho3Ай бұрын
goat, thanks!
@ProlificOaktreeАй бұрын
🔥🔥
@HosneAra-se5hcАй бұрын
when use group by category in my google sheet and whenever add new categories in the bottom of the two column it comes first of the column and closest column two cells items move with this how to fix these
@ohnoez768Ай бұрын
Very helpful, thank you so much!
@ProlificOaktreeАй бұрын
Glad it was helpful!
@plazafriburgo4539Ай бұрын
BRO JUST SAVED ME HOURS
@ProlificOaktreeАй бұрын
BRO
@fp30eАй бұрын
I have Tools, but no Script Editor. Guessing this function no longer exists? It's quicker just to type in the Label name. Great video. Thank you
@ProlificOaktreeАй бұрын
You need to have adequate permissions to the file to use Apps Script with it. That's likely the issue.
@fp30eАй бұрын
@@ProlificOaktree Hello, Thank you for your reply. It's my PC, not a work's PC with limitations. I'll try and work it out. Take care.
@davidmvermillionАй бұрын
You made an invisible and weightless turkey. You can do that, right?
@ProlificOaktreeАй бұрын
Um yeah, just did that for this thanksgiving!
@SamreenEhsanАй бұрын
very helpful
@ProlificOaktreeАй бұрын
Glad to hear that
@eerwin2494Ай бұрын
6 years later still works
@ProlificOaktreeАй бұрын
Still chuggin' along.
@russcharif4320Ай бұрын
Excellent-- thank you!
@ProlificOaktreeАй бұрын
You're very welcome!
@netboy1102Ай бұрын
I tried glide for few minutes, and gave up, because that is for skilled developers nothing, for newbies too complicated.
@ProlificOaktreeАй бұрын
Ooof
@melissasaboljtАй бұрын
I'm getting a blank row under the header items when I do the Query. I can't figure out how to get rid of it, though I'm sure it is simple. Please help. This is my formula =QUERY(A6:G,"select B, sum(G) group by B",1). Thank you.
@melissasaboljtАй бұрын
Also, is there a way to remove the word "sum" from the header?
@ProlificOaktreeАй бұрын
Try this: sheetshelp.com/query-remove-blank-rows/
@ProlificOaktreeАй бұрын
Adjust the range you're using or the third parameter of the query that deals with header rows.
@melissasaboljtАй бұрын
@@ProlificOaktree thank you for replying, but maybe there is a miscommunication. The blank row I'm trying to get rid of is right under the header row of the Query between the header and the results. even with a simple table it still shows up. it is just frustrating and I'm curious why, but not that big of a deal. This video was very helpful. I appreciate it.
@SheetsHelpАй бұрын
@@melissasaboljt It sounds to me like the URL I gave you addresses this. 🤷