How to convert pop out date in mm/dd/yyyy in google sheets 2024
@kayjay92290Күн бұрын
Is there away to make two slots open for the same time on one day? Is there away to make the calendar only open certain of the month? For example: I’m trying to set up my time for every other month on the third Friday. Is that possible?
@sakthivel-he3xf3 күн бұрын
How to calculate when the coupon has been paid out on every cross years with a leap year (ACT/ACT)
@dannaking83555 күн бұрын
Sir, I appreciate you showing people how to do this! You just saved me from missing some serious points on my essay that's due today.
@joelbennett38605 күн бұрын
Thank you
@kjvbible16116 күн бұрын
This is Exel not Google Sgeets!!!
@ProlificOaktree4 күн бұрын
Says who?
@lhmonticelli6 күн бұрын
Thank you sir. Great stuff
@electricloco-yt9ze7 күн бұрын
i want change th format of date like dd/mm/year
@TechnoEveryday7 күн бұрын
Cool🎉🎉🎉🎉
@mayowa69557 күн бұрын
Thanks for making it easy to understand. Love from Nigeria.
@ProlificOaktree7 күн бұрын
Thanks! Right back at you.
@TrinityThr3338 күн бұрын
💗💗💗
@michaelbodner19378 күн бұрын
Thanks for this- clear, concise, and it works! Much appreciated.
@ProlificOaktree8 күн бұрын
Glad it helped!
@biancalandis9 күн бұрын
OMG, thank you for this. I was receiving an error on a sheet that was given to me and I just needed to change the validation rules. Thank you!!
@ProlificOaktree8 күн бұрын
You're welcome!
@monkmodementor9 күн бұрын
Very useful! Thank you!
@ProlificOaktree8 күн бұрын
Glad it was helpful!
@shiro4u19 күн бұрын
Concise. Clear. Understood.
@ProlificOaktree8 күн бұрын
Just what I hoped. Thank you!
@jchicchon12 күн бұрын
Thx master!! Gracias MAESTRO!!
@ProlificOaktree12 күн бұрын
You're welcome! Glad you liked it.
@WenSaiPanther12 күн бұрын
Hi. My goal is to find a way to copy a cell and text color to copy the origination of a cell's and text's colors. For example, cell a2 has the word "completed" and the text is bold red with the cell's color purple. When I type "completed" in cell c35, it automatically makes that cell's color purple, and the word becomes bold and red. How can I do that without a script?
@mohamedmeshref13 күн бұрын
Excellent video, I wish you can add Excel files to apply the video on it
@ProlificOaktree12 күн бұрын
Excel? What's Excel!
@nithans13 күн бұрын
Awesome Thank you so much
@ProlificOaktree12 күн бұрын
You are very welcome
@nategraham398013 күн бұрын
hey thanks a a lot! I appreciate the simplicity of your teaching style. going through the data certificate course on google and this has been a great resource!
@ProlificOaktree13 күн бұрын
Glad I could help!
@latuman15 күн бұрын
Copying m3 from the web just types "m3" like normal. The number 3 is not special in any way. So that doesn't work. Also cant find a special symbol for cubic meters
@ProlificOaktree12 күн бұрын
What is m3?
@latuman12 күн бұрын
@@ProlificOaktree cubic meter
@ProlificOaktree12 күн бұрын
It's not available in the add-on but you can use the function: =char(13221)
@flip752716 күн бұрын
Thanks
@ProlificOaktree12 күн бұрын
Welcome
@tentavaruag16 күн бұрын
Very useful. Thank you.
@ProlificOaktree12 күн бұрын
You're welcome!
@sarakidstoons16 күн бұрын
You're a Savior for me... Thanks a lot...
@ProlificOaktree12 күн бұрын
Happy to help
@frogboy83117 күн бұрын
this was so cool. thank you!
@ProlificOaktree12 күн бұрын
Glad you liked it!
@emma298217 күн бұрын
Very easy and helpful, thanks
@ProlificOaktree12 күн бұрын
Glad to hear that!
@DamienDee1918 күн бұрын
My boss used this feature a week ago and it really caught my attention. Thanks for this tutorial!
@ProlificOaktree12 күн бұрын
No problem. I'd say it's very underused.
@JosephSutton-t8r19 күн бұрын
so how do we get it to update automatically. For example, if I go in my excel and change the colors daily i don't see the updates to the sums.
@jiju118519 күн бұрын
very well explained. succinct. and i liked the f4 pro tip, I didnt know that. Thanks alot :)
@ProlificOaktree12 күн бұрын
My pleasure!
@Ritums8819 күн бұрын
Thanks. Simple and clear!
@ProlificOaktree12 күн бұрын
You're welcome!
@alohathailand747720 күн бұрын
nice
@ProlificOaktree12 күн бұрын
So nice
@vskhosa21 күн бұрын
Hi, this is a very clear explanation of Named Ranges. I am trying to see how I can use Named Ranges to create dynamic drop downs. Is it something that's doable in Google Sheets?
@dineshr671326 күн бұрын
Sir, How t o list/ add duplicate instead just highlighting?
@sweetmask169028 күн бұрын
Hi, I have a problem to solve a night differential from 1:00am to 6am and I can't solve it with formula
@ProlificOaktree22 күн бұрын
Make sure you have dates with the times then you can work with them as numbers.
@sweetmask169021 күн бұрын
@@ProlificOaktree huhu it’s so hard
@ProlificOaktree21 күн бұрын
@@sweetmask1690 That's why I made this add-on: workspace.google.com/marketplace/app/timedif/1098005795621
@SylvioMedeirosАй бұрын
Looks like every 2 months or so i have to go back to this video, its so good. Save me hours of work in less than 3 minutes
@ProlificOaktreeАй бұрын
Well, we're always happy to have you back.
@lasanthicolambage2139Ай бұрын
Thank you ! It solved my issue, Thank you very much!
@ProlificOaktree28 күн бұрын
Glad to hear it!
@TarginaldoАй бұрын
Is It possibile to do a dx and sx page number in order to set up the documento for a proper print?
@simonfernandes8672Ай бұрын
I have a paid google workspace Business Account. How do i enable this feature?
@ProlificOaktree22 күн бұрын
It should be on by default. If the options aren't there, you will have to talk to your admin.
@LorrainePeterson-nz9thАй бұрын
If a simple table is used in a google doc, is there a way to specify row headers to make it readable?
@sibastouneАй бұрын
Thank you!
@ProlificOaktree22 күн бұрын
You're welcome!
@lauren20007892Ай бұрын
Thank you this was very helpful!
@ProlificOaktree28 күн бұрын
I'm so glad!
@alfredoiglesias7856Ай бұрын
Thanks for this!
@ProlificOaktree28 күн бұрын
Sure thing!
@michaelkwiatkowski3732Ай бұрын
all i get is errors reading Ref! and it won't sort anything new I put in
@ProlificOaktreeАй бұрын
I'd be glad to help you out. Email me at [email protected] and I can setup a video call to see why.
@justinebatchelder728Ай бұрын
Super helpful!
@flavi100Ай бұрын
Soy de chile, ningún video en español me ayudó, sólo el tuyo, Te agradezco!! 😀
@Lorgayle1Ай бұрын
Thanks so much!! Clear instructions, easy to understand, and it works! I came here for the 2nd option, and you didn't disappoint .
@ProlificOaktree28 күн бұрын
Glad it helped!
@chrissmart7639Ай бұрын
a thousand times thank you!!!!
@ProlificOaktree22 күн бұрын
Thousand times welcome
@austinlehn3304Ай бұрын
Reference citation: Prolific Oaktree. (2017, August 19). Google Docs - Hanging Indent [Video]. kzfaq.info/get/bejne/brKmnc2fuJvdZn0.html
@ProlificOaktreeАй бұрын
What is this?
@brijendrasingh1Ай бұрын
Thanks
@ProlificOaktree22 күн бұрын
Welcome
@user-jo8uh5sl2sАй бұрын
*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*
@ProlificOaktree22 күн бұрын
No, you'd have to try something like this: kzfaq.info/get/bejne/i99yhruY2ZjDiZs.html