Progress Bar in Google Sheets

In this how to, Lean Strategies International LLC will show you how to make a progress bar in #googlesheets using a countif formula and a sparkline formula. As a reminder google sheets is part of the google #workspace platform.
Please #subscribe #share and #like and #comment on the Video to support the channel Here and receive more FREE Content: / @leanstrategiesinterna...
Want to sign up for more advanced features on google #workspace and help the channel out? Visit: www.leanstrate...
The Formula shown in this video is:
=sparkline(COUNTIF(C2:E2,"TRUE"),{"charttype","bar";"max",3})
** Note: you will need to select the appropriate cells where "C2:E2" is.

[@kennethparker6005]

Great video!!! I haven't used spark-line before but you have made it look relatively easy. Thanks.

[@LeanStrategiesInternationalLLC]

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

[@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!

[@afitosaleh]

Halo, great video, thank you so much, I have a question, can we put the percentage number in progress row?

[@LeanStrategiesInternationalLLC]

Thank you for your question @afitosaleh1243. Here is a link to a video that will show you how to generate a progress bar with a percentage in Google Sheets. Please feel free to contact us if you need anything else: kzbin.info/www/bejne/jpyveXmAmJ2cpLc

[@andreibrahinets9799]

Thanks , how to do it vertical progress bar?

[@LeanStrategiesInternationalLLC]

Great Question! Thank you @andreibrahinets9799. Check out this video for a brief introduction to Vertical (column) progress charts. Please feel free to #share kzbin.info/www/bejne/jWjVhq2HjNtskLM

[@KitKat-ki7vi]

Is there a way to change the color of the progress bar?

[@LeanStrategiesInternationalLLC]

Thank you for the question @KitKat-ki7vi We hope this video will help you in changing the color of your progress bars. If you were looking for something else please feel free to reach out and we will do our best to help: kzbin.info/www/bejne/Z4SXYpyNhsdpbrM

[@brilliantbrainz6470]

Great video, my sparks are only showing 1 colour even afterI select a data set

[@LeanStrategiesInternationalLLC]

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.