Others said it can only be done with app scripts, but you’re amazing-you actually achieved it directly with a formula. So impressive!
@icyherenow4 ай бұрын
you saved my life oh my God
@BIGjeffSanDiego4 ай бұрын
Perfect! So helpful! Thank you!
@DzmitryPetrushenka5 ай бұрын
very useful! thank you!
@LeanStrategiesInternationalLLC5 ай бұрын
Thank you so much for your kind words @DzmitryPetrushenka ! Glad you found the video useful. If you have any questions or need further clarification on anything, feel free to ask!
@kronen_bob6 ай бұрын
HUGE help! I searched other ways and none of the functions worked until I found your video! Thank you for your videos.
@LeanStrategiesInternationalLLC6 ай бұрын
Glad it helped @kronen_bob If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@johnjershoff47716 ай бұрын
What a great pneumonic!
@LeanStrategiesInternationalLLC6 ай бұрын
Thank you @johnjershoff4771. The one piece pneumonic is in our Pull Systems course. If you would like more information on it you can visit: www.leanstrategiesinternational.com/pullsystemscourse.html
@BH-gh6qm7 ай бұрын
some unique ears on this fella
@LeanStrategiesInternationalLLC6 ай бұрын
They sure are. Cellular layouts are also a powerful way to reduce noise in a plant as they provide a cell that encloses much of the sound. Do you use cellular layouts? Learn more about Cellular manufacturing here: www.leanstrategiesinternational.com/glossary/cell
@SephinAlexander7 ай бұрын
Thank you!
@LeanStrategiesInternationalLLC6 ай бұрын
You're welcome @SephinAlexander! If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@migueljaballas817 ай бұрын
Big help man!
@LeanStrategiesInternationalLLC7 ай бұрын
Awesome! Happy to help @migueljaballas81 we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@Ultimate-dude3747 ай бұрын
Yes but I didn’t have my phone so I couldn’t record😭
@LeanStrategiesInternationalLLC7 ай бұрын
Glad you got to see it! Sorry you didn't get a recording.... :( Maybe next time?
@Ultimate-dude3747 ай бұрын
I will do that but it will be a long time to wait
@LeanStrategiesInternationalLLC7 ай бұрын
Fun! Thanks for visiting the community @isaiahuribe8677
@eeeeee-j5e7 ай бұрын
yes
@LeanStrategiesInternationalLLC7 ай бұрын
Awesome! Thanks for sharing.
@De_Doods7 ай бұрын
What did he share.??
@LeanStrategiesInternationalLLC7 ай бұрын
Excellent question! They shared that they got to see the solar eclipse. Did you see it @Dood281 ?
@ZoyaBaranovskaya8 ай бұрын
Wooow🎉great,brilliant solution! Without difficult scripts and soooo simple❤ thank you sooo much 😊
@LeanStrategiesInternationalLLC8 ай бұрын
You are very welcome @user-cd6yn5ny7j we appreciate the your #comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@shotgunheist65368 ай бұрын
big thanks
@LeanStrategiesInternationalLLC8 ай бұрын
You are very welcome @shotgunheist6536 we appreciate the #graditude of your comment in the #community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@tetianahirun57658 ай бұрын
Great explanation
@LeanStrategiesInternationalLLC8 ай бұрын
Thank you @tetianahirun5765. You can find more #googleworkspace content here if you would like: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@WarmApplePye8 ай бұрын
My date keeps showing 30th December 1899?
@LeanStrategiesInternationalLLC7 ай бұрын
Hi @WarmApplePye, thank you for asking this. The default date in #googlesheets is December 30, 1899. With that in mind your date will default to this time. Try checking your box, unchecking it and then checking it again. If your sheet is setup and formatted the same way as the one in the video this will correct the date. Thank again for being a part of the community. If you would like more helpful videos on #Googlesheets please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@kennethparker60059 ай бұрын
Great video!!! I haven't used spark-line before but you have made it look relatively easy. Thanks.
@LeanStrategiesInternationalLLC9 ай бұрын
Glad it was helpful @kennethparker6005! If you would like more content on Google Workspace Checkout this playlist we have: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@karolpaz40909 ай бұрын
Perfect video, thanks so much!
@LeanStrategiesInternationalLLC9 ай бұрын
Thank you @karolpaz4090 we appreciate the #positive comments in the #community. If you would like more helpful videos on Google Sheets, please feel free to visit: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@mas-daym9 ай бұрын
Woahhh thank u sir, I learn a lot from this :D
@LeanStrategiesInternationalLLC9 ай бұрын
Thank you for sharing that @mas-daym. If you would like more #youtube content on #googleworkspace please follow the link here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@soumiamoujane36959 ай бұрын
Can I do this worksheet in Microsoft Excel?
@LeanStrategiesInternationalLLC9 ай бұрын
Hi @soumiamoujane3695 and thank you for commenting in the community. There are many different ways to create "progress bars" in excel. Here is a link to some other videos on KZbin that may be helpful. Thanks again for commenting. kzbin.info?search_query=Creating+a+Progress+Bar+in+Excell
@abdulwahid-u8x9 ай бұрын
What ?!
@LeanStrategiesInternationalLLC9 ай бұрын
Thanks for the question @user-sb8jj2in9i. Lot size and Lot sizing can be a difficult concept to understand. If you have a specific question please feel free to share it here or, for more information on Lot Size please visit: www.leanstrategiesinternational.com/glossary/lot-size
@unknown-zr6ef10 ай бұрын
Thank you friend
@LeanStrategiesInternationalLLC10 ай бұрын
You are very welcome. Please feel free to #share with others.
@ikatefx10 ай бұрын
Thank you!!
@LeanStrategiesInternationalLLC10 ай бұрын
You're Welcome! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@StellaCOBB-m3c10 ай бұрын
Thank you sir. You've just saved my day!!
@LeanStrategiesInternationalLLC10 ай бұрын
Glad this helped! Please feel free to check out more of our #googleworkspace videos here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
10 ай бұрын
Thanks! It was really helpful!
@LeanStrategiesInternationalLLC10 ай бұрын
Glad it helped @Aprenderinglesdlc. For More of our Workspace Wednesday Content Please Feel Free to Visit: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@bheinaudiobenson239310 ай бұрын
The inspector looks nice person And beautiful and the production area looks so good and neat.
@LeanStrategiesInternationalLLC10 ай бұрын
We agree @bheinaudiobenson2393! The area looks like its in great 5S Condition and in the background there is even an andon light. Way to go superstar inspector! For more information on 5S visit: www.leanstrategiesinternational.com/glossary/5s-system. And, for more information on Andons visit: www.leanstrategiesinternational.com/glossary/andon
@ShamsolHassan10 ай бұрын
And as part time, she's a black Jack dealer..
@LeanStrategiesInternationalLLC10 ай бұрын
Thanks for commenting Shamsol Hassan (@user-ne1sz8mk9r). She definitely would be a good one!
@prototype_0xD110 ай бұрын
So this is a visual and partial function test. I'd like to see an actual load/short test.
@LeanStrategiesInternationalLLC10 ай бұрын
Thank you for your contribution @prototype_0xD1. We'd love to see other forms of tests too. In the case of this example it may be placed in other portions of the process, as we only a small piece of it. None the less this employee is an allstar. Also, you can learn more about function checks here: www.leanstrategiesinternational.com/glossary/function-check8292825
@72FrostyOne10 ай бұрын
Function check of circuit breakers, she is quick!
@LeanStrategiesInternationalLLC10 ай бұрын
Thank you for sharing @youremadimeducated. You can learn more about Function Checks Here: www.leanstrategiesinternational.com/glossary/function-check8292825
@tsscapac722610 ай бұрын
thank you , i am using it
@LeanStrategiesInternationalLLC10 ай бұрын
Glad to hear it @tsscapac! If you want more Google workspace tips check out this playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW&si=94iq8-SjEg_o191G
@moisessouza284510 ай бұрын
Pelo jeito vai acabar a comida da mamãe e da vovó 😂😂😂
@LeanStrategiesInternationalLLC10 ай бұрын
Talvez? LOL
@brilliantbrainz647010 ай бұрын
Great video, my sparks are only showing 1 colour even afterI select a data set
@LeanStrategiesInternationalLLC10 ай бұрын
Thank you. There are several reasons this may happen: color code changes, formatting, etc. If you require further more specific assistance in resolving this, please consider sharing your formula and the relevant sheet. If we can't get to it right away, somebody in the community may also be able to assist. Thanks for commenting.
@sion945310 ай бұрын
Great explanation thank you!!
@LeanStrategiesInternationalLLC10 ай бұрын
Glad it was helpful @sion9453. Please feel free to #share it with your friends. Also, if you would like more #supplychain and #operations content please feel free to visit our website here: www.leanstrategiesinternational.com/
@StephenEdwards-h2j11 ай бұрын
Doc brown would be proud
@Cola_mans11 ай бұрын
This is not stir fry this is spin fry
@LeanStrategiesInternationalLLC11 ай бұрын
😆
@Santorien11 ай бұрын
Lmfao what am I watching? and how is it not spilling?
@LeanStrategiesInternationalLLC11 ай бұрын
Automation in the Kitchen 😀. What do you think @Santorien? Taste Good?
@SandeepSharma-fd6zz11 ай бұрын
Fill Rate Percentage: 78.33%. Since the business is in medical segment, I will order from other supplier to meet the demands and this solution is possible of Fill rate concept only. Thank You sir.
@LeanStrategiesInternationalLLC11 ай бұрын
Great Job @SandeepSharma-fd6zz! If you are interested in more information on Fill Rate Please Feel Free to Visit: www.leanstrategiesinternational.com/glossary/fill-rate
@Robi01-x6t11 ай бұрын
I have follow this to use "=DAY(TODAY())" with time zone CST and iterations on in settings but all dates get updated ever day automatically, is there any way so that the past date stay same and dont get updated? any quick response would be appreciated .
@LeanStrategiesInternationalLLC11 ай бұрын
Thank you for asking @user-uf3ol7kc4v. It looks like your formula would update everyday. Try watching the video (kzbin.info/www/bejne/d6SqqqKhfJt8irssi=5snaA7c5SmbK3vKl) and adjusting your formula based on the video. Please note the cell references that you use may be different from the video.
@AlexTarr-l9q11 ай бұрын
Thank you!
@LeanStrategiesInternationalLLC11 ай бұрын
You're welcome! For more Tips on Google Sheets Visit the Link Here: kzbin.info/aero/PLX_1L8RY_Uz_7aPeXFi52OCFdSK03wUbT
@GabrielAmarodeAlmeida Жыл бұрын
When i type , after false the word false change to black insted of stay in blue.
@LeanStrategiesInternationalLLC11 ай бұрын
Thanks for sharing this. You might want to re-check your formula.
@karthiksree1598 Жыл бұрын
Customer
@LeanStrategiesInternationalLLC Жыл бұрын
Very Good @karthiksree1598. For More Information on Pull Systems Visit: www.leanstrategiesinternational.com/glossary/pull-system
@goochnukem4950 Жыл бұрын
So have better equipment and higher double triple the people kind of the opposite of what lean does
@LeanStrategiesInternationalLLC Жыл бұрын
Thank you for sharing your thoughts @goochnukem4950. In this example we see two activities that occur. Internal Setup Activities (www.leanstrategiesinternational.com/glossary/internal-setup) and External Setup Activities (www.leanstrategiesinternational.com/glossary/external-setup-time). While improving tooling and resources is definitely noted in this example the biggest improvements actually occur during the external. For example: People are in position prior to the vehicle arriving, tools are positioned appropriately, materials are on site and in place and each resource has a standard procedure to follow. In addition to this you are correct, internal improvements occur as well. Resources are balanced, tools are improved and capacity is expanded. It is important to note that these improvements, while not nearly as large as the activities that are improved during external changeover time can contribute to improved changeover times as well and typically would be performed only after reductions in muda ( www.leanstrategiesinternational.com/glossary/muda) or other non-value adding (www.leanstrategiesinternational.com/glossary/non-value-added) activities have been performed.
@marylepage960 Жыл бұрын
Thank you for making this video! I've wanted a function like this for a while
@LeanStrategiesInternationalLLC Жыл бұрын
No problem! Glad We could help. Thanks for being a part of the community. Also, If you are interested in more Google Workspace Content Please Visit This Great KZbin Playlist: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@the_human_guide Жыл бұрын
Super helpful. Your branding is hilarious. It gives me Nepolean Dynamite vibes,
@LeanStrategiesInternationalLLC Жыл бұрын
Glad you liked it and thank you. Napoleon Dynamite is a great movie! ┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌█████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌███████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌███┌███┌┌┌┌┌┌┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌████████████┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌ ┌┌████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌ ┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌█████████┌┌ ███┌┌┌┌█████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌█████┌ ██┌┌┌███████┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌███┌ ██┌┌┌┌███┌┌┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ███┌┌┌┌┌┌┌┌┌┌┌█████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌┌┌┌┌┌┌████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌████████████┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌██████┌┌┌┌┌┌┌████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌███┌┌┌┌┌┌┌┌┌┌┌██████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌████┌████┌██████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌██┌ ┌┌┌████████████┌┌┌┌┌███┌┌┌┌┌┌┌┌┌┌┌┌┌███┌ ┌┌┌┌██┌┌┌┌┌┌┌┌┌┌┌███████┌┌┌┌┌┌┌███████┌┌ ┌┌┌┌████┌┌┌┌┌┌████████┌┌┌┌┌┌┌┌████████┌┌ ┌┌┌┌┌████████████┌┌┌███┌┌┌┌┌███┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌█┌█┌┌┌┌┌┌███┌┌┌███┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌███┌┌┌┌┌┌█████┌┌█████┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌██████████████████┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌██████████████┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌ ┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌┌
@johnjershoff4771 Жыл бұрын
This video is very helpful! Thank you the function works perfectly. Do you have one that includes a percentage?
@LeanStrategiesInternationalLLC Жыл бұрын
Awesome! And, thank you. Yes we have a progress bar Chart with a Percentage. Try this out and let us know if you have any questions: kzbin.info/www/bejne/jpyveXmAmJ2cpLc
@HasanJaffrey Жыл бұрын
This is helpful, thank you! Is there a way to add % to the progress bar?
@LeanStrategiesInternationalLLC Жыл бұрын
You’re very welcome. And, great question @HasanJaffrey. Try this video and see if it helps. Please let us know if you have any other questions….. kzbin.info/www/bejne/jpyveXmAmJ2cpLcsi=qu2DZ4WfaKB1iO3r
@stefanomastropietro9040 Жыл бұрын
Work in Process or progress ?
@LeanStrategiesInternationalLLC Жыл бұрын
Hi @stefanomastropietro9040 Great question! WIP, is referred to as Work in progress and/or process. Both refer to one form of inventory. WIP is the work that is in process or production at a stage that falls between raw material and finished product. You can find more information Here: www.leanstrategiesinternational.com/glossary/work-in-progress-wip
@PBTophie Жыл бұрын
This works a treat! After writing a script that didn't work perfectly, this was all I needed. Hilarious. Thanks a million!
@LeanStrategiesInternationalLLC Жыл бұрын
We are happy to help. If you're interested in more Google Workspace Tips Please Visit the Link Here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW
@johnjershoff4771 Жыл бұрын
This is an awesome video! Works perfectly on this template. I’ve also used in other templates with only minor changes. Lean Strategies International LLC should make a Google Sheets series.
@LeanStrategiesInternationalLLC Жыл бұрын
Glad it was helpful, @johnjershoff4771! You can find more tips on Google Workspace Here: kzbin.info/aero/PLX_1L8RY_Uz_hZNe3UX41-1zlUUasB9JW&si=1x7QQP-yk5c0XOaI
@johnjershoff4771 Жыл бұрын
@@LeanStrategiesInternationalLLC love it!
@JessicaFrank-m9m Жыл бұрын
Finally found an easy solution to this timestamp task. Thank you! Also, looks like the Fonz got into spreadsheets after Happy Days?