=sparkline(D2,{"charttype","bar";"max",E2}) the code

@AirdropDaily-pe7wz

17 күн бұрын

thanks man you saved my time

@Imranqureshi-fz8kh

7 күн бұрын

=sparkline(d2,{"charttype","bar";"max",e2})

Badass. I spent all morning looking for something like this. Everywhere else I looked was convoluted. Much appreciated.

@steinisfinance7979

2 жыл бұрын

Great to hear! Thanks for leaving a comment :)

@ryanlynch290

2 жыл бұрын

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

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-fg6cl

6 ай бұрын

Thank you 🤩

@alexivanov3984

4 ай бұрын

real heroes don't wear capes

@victorb6367

4 ай бұрын

Thanks!!! 🤓

@nespppp

24 күн бұрын

Vielen vielen Dank!!! Du hast mein Leben gerettet!

that was pretty neat and i really loved it , thank you for this man it helped me a lot

Amazing tutorial, very didactic and straight to the point

@steinisfinance7979

3 жыл бұрын

Thanks a lot for the comment! Im glad you liked it 😊

Thanks!

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)

Hi, thank you for posting this video. I have thinking bout adding a progress bar for my budgeting portfolio to make it more exciting! :)

@steinisfinance7979

3 жыл бұрын

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!

what if you wanna add multiple conditions? like progress 30% orange 70% yellow?

great video! is there a way to show a % progress on the bar?

Thanks for your video. Short Concise and very cool. 👊🏼💥

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

Thank you - super helpful!

Hi Thanks for this,, can we have a copy of the whole formula,, I can barely see it in the video..Thanks

Amazing thank you! Any idea how to change the color of the bar by any chance??

Function SPARKLINE parameter 2 option max expects number values. But '' is a text and cannot be coerced to a number.

thank u

Thanks , how to make a progress bar vertical ?

Thank youuu

is it possible to fill the remaining side of the progress bar that is left empty with a different color bar as well?

@steinisfinance7979

3 жыл бұрын

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!

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..

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 ??

@steinisfinance7979

3 жыл бұрын

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! 😀

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

Sorry. I did =SPARKLINE(C5,{"charttype","Bar","Max",D5;"COLOR1";IF(C5

@samrangaful

Жыл бұрын

u have mistakes

@edwinej79

5 ай бұрын

Nope this did not work. My values are currency. Is that why?

4k uhd

Is not working.Can you put what you type in a coment please.Thank you

@kubus_puchatek

Жыл бұрын

use ; and \ instead of commas

Doesn't work

Doesn’t work for me.

@kubus_puchatek

Жыл бұрын

use ; and \ instead of commas

@Hgames_RBLX

Жыл бұрын

Still doesn’t