Progress Bar that Changes Colors Based on Checkboxes in Google Sheets

Video Description

In this how to, Lean Strategies International LLC will show you how to create a Progress Bar that Changes Colors Based on Checkboxes in Google Sheets using a countif formula, sparkline formula and a switch formula. As a reminder #googlesheets is part of the google #workspace platform. - Please #subscribe and Like the Video to support the channel Here and receive more FREE Content: https://www.youtube.com/channel/UCTo9HhaU7S1hnKxb8Munlvw?sub_confirmation=1 Want to sign up for more advanced features on google #workspace and help the channel out? Visit: https://www.leanstrategiesinternational.com/workspace.html Learn how to build this progress bar and many more in this Playlist: https://www.youtube.com/playlist?list=PLX_1L8RY_Uz_UBTNpbj89UJPWoQX8cFP4 The Formula shown in this video is: =Sparkline(countif(C2:E2,True),{"charttype","bar";"max",3;"color1",Switch(countif(C2:E2,True),3,$K$5,2,$K$4,1,$K$3,$K$3)}) ** Note: you will need to select the appropriate cells where "C2:E3" is. Also, when entering your color code (example: # da1313) you will need to select or enter the appropriate hex color code. Please feel free to comment on this video and we would love to get back to you.