Badass. I spent all morning looking for something like this. Everywhere else I looked was convoluted. Much appreciated.
@steinisfinance79792 жыл бұрын
Great to hear! Thanks for leaving a comment :)
@ryanlynch2902 жыл бұрын
@@steinisfinance7979 Hey! Thanks for replying to my comment. I'm a contractor (design-build, I do everything, a lot of welding in particular). I'm actually building a sheet for project management functionality that I haven't seen anywhere else, and I've looked at all the different CRMs, all the contractor apps, Basecamp, everything. I'm going to create a startup to make the construction industry better. This will be part of it! I'm planning to convert my sheet to an app. I don't plan on being the best developer or engineer in the world, more the big picture person, but I love to get my hands dirty and need to know enough coding etc. to be able to work and talk shop with anyone that might work for me eventually. This is going to be exciting. I really appreciate people like you putting content out. Thanks so much for this video!
@OffiGameWave10 ай бұрын
So as someone from germany I need to input it this way because with the comma it doesn't work (maybe because we use comma for decimal numbers instead of a point) =SPARKLINE(B2;{"charttype"\"bar"; "max"\C2})
@Caroline-fg6cl8 ай бұрын
Thank you 🤩
@alexivanov39846 ай бұрын
real heroes don't wear capes
@victorb63676 ай бұрын
Thanks!!! 🤓
@nespppp3 ай бұрын
Vielen vielen Dank!!! Du hast mein Leben gerettet!
@alexbannenberg6 күн бұрын
Sau stark, danke! Hast du auch den Code für die bedingte Formatierung der Farbe rausbekommen? 👀 bekomm das nicht hin haha
@omarsaad3617 ай бұрын
=sparkline(D2,{"charttype","bar";"max",E2}) the code
@AirdropDaily-pe7wz2 ай бұрын
thanks man you saved my time
@Imranqureshi-fz8kh2 ай бұрын
=sparkline(d2,{"charttype","bar";"max",e2})
@THE_VALF_Ай бұрын
Thankz
@rayzensenpai2 ай бұрын
that was pretty neat and i really loved it , thank you for this man it helped me a lot
@MatheusSilva-wn7iy3 жыл бұрын
Amazing tutorial, very didactic and straight to the point
@steinisfinance79793 жыл бұрын
Thanks a lot for the comment! Im glad you liked it 😊
@speklex779Ай бұрын
Exactly what I looked for. Thank you
@itsvansfinance50803 жыл бұрын
Hi, thank you for posting this video. I have thinking bout adding a progress bar for my budgeting portfolio to make it more exciting! :)
@steinisfinance79793 жыл бұрын
I hope it helps you out! For sure, visual presentation is always more fun to look at then just numbers haha! Thanks for stopping by and commenting, I appreciate it!
@RaviShukleMarketing Жыл бұрын
great video! is there a way to show a % progress on the bar?
@Americawtff Жыл бұрын
Theoretically could you make a progress bar for potential employees? Filled out Resume>Potential Candidate>Call back>interview>hired ..? Depending on what step they were on, it would show 20%/40%/60% (or more/less depending on how many steps)
@donterrencerollon39322 жыл бұрын
Hi Thanks for this,, can we have a copy of the whole formula,, I can barely see it in the video..Thanks
@abbylaurente4830 Жыл бұрын
Thank you it works. However, how can i also display as text the actual value of the 'current' Note: am creating the progress bar on a diff tab, hence need to also show the value
@Cathee456 ай бұрын
Amazing thank you! Any idea how to change the color of the bar by any chance??
@andreibrahinets9799 Жыл бұрын
Thanks , how to make a progress bar vertical ?
@surreshk Жыл бұрын
what if you wanna add multiple conditions? like progress 30% orange 70% yellow?
@khalidfaisal899929 күн бұрын
You can nest the condition
@IanMartinAdams2 ай бұрын
Thanks!
@Roy-ys6yf3 жыл бұрын
Amazing video! Thanks! I'm still looking for a way to put the value (in your video "current") in de same cell... I know it is possible in Excel but in Google Sheets ??
@steinisfinance79793 жыл бұрын
Thank you for the comment! I haven't found a solution for that yet im afraid. I think the difference is that in Excel you use conditional formatting for the cell but in Google Sheets you have to use the formula bar to use the function. I will get back to you if I find a solution! 😀
@hoty55533 ай бұрын
Function SPARKLINE parameter 2 option max expects number values. But '' is a text and cannot be coerced to a number.
@rebeccagarzon62752 жыл бұрын
Thank you - super helpful!
@acslater4576 ай бұрын
Google sheets says: :"Error: Circular dependency detected. To resolve with iterative calculation, see File > Settings." and then when I go to that Iterative calculation I don't know what to put..
@imr4nkhan Жыл бұрын
Thanks for your video. Short Concise and very cool. 👊🏼💥
@adamasimolowo82853 жыл бұрын
is it possible to fill the remaining side of the progress bar that is left empty with a different color bar as well?
@steinisfinance79793 жыл бұрын
Yes no problem! You use "color2" instead of "color1". So you would add to the formula ;"color2","yourcolorhere". Let me know if it works for you!
@katherineperez45477 ай бұрын
thank u
@Homicidoll2 жыл бұрын
Fantastic tutorial, the only one I could find that helped. But now I'm running into an error message where I haven't input my data yet. Is there a way to ignore if the cells are empty? I can't seem to wrap my head around it. I have =SPARKLINE(D2,{"charttype","bar";"max",E2;"color1",IF(D2
@yohanperera69 Жыл бұрын
Add "IFERROR(" after the = sign and hit enter
@quimsabate30342 жыл бұрын
Sorry. I did =SPARKLINE(C5,{"charttype","Bar","Max",D5;"COLOR1";IF(C5
@samrangaful Жыл бұрын
u have mistakes
@edwinej798 ай бұрын
Nope this did not work. My values are currency. Is that why?
@noviandriyani83932 жыл бұрын
Thank youuu
@Methosu7 ай бұрын
4k uhd
@sebigeorgiu95732 жыл бұрын
Is not working.Can you put what you type in a coment please.Thank you