I used this to make a progession of images for when I check something off my list of Bills for the month. When I first tried, the COUNTIF function wasn't working (presumably because the image was off to the side of my chart, not aligned with the column it was pulling data from). So, to mend this issue, I did a cell with COUNTIF at the bottom of the column I was pulling from, then used VALUE in my SWITCH formula to pull whatever the number given by COUNTIF was. And it worked swimmingly. Hope this helps someone in the future.
Thanks for the video! I have a cell where I put a numerical "goal" and beside it a cell that shows the "actual" total of checkmarks for each column. I want to make a progression of images based on the percentage achieved of the "goal" cell. What formula should I use? Also, please put the formula for Apps Script if you're familiar with using that. Thanks!
this is awesome!!! I'm doing my task planner like this, but, what if instead of the specific number, i want to put a percentage of my progress? I dont have an specific number of tasks, so i'd be nice to keep track of my progress from 0% to totally done (100%) I tried to do it by myself, but it didnt work! :C
@@BetterSheets Could you please share an example of how to achieve this effect with an IFS() formula? I am struggling to get this to work. Thank you so much!
I need my tasks to be completed stage wise, like if we are on project transformation stages it should strictly tick stage wise like stage 1, tick then 2 tick, if directly my 4th stage is done by ticking on 4th stage box the earlier 1-2-3 stage should automatically get ticked. Please help me
How could we upload our own images to be used with this? I save the image and then open it in google to get a URL, but Sheets says that the URL "is not a valid url." 😿
A very quick remedy for this is to open a Google Drawing, set up your own image, and then publish from the Share menu on the Drawing. Hope that helps :)
Maybe I have not thought this trough - but my first reaction is: why do you need „switch“ in the formula, can‘t you just do an IF X1=true, do this, else if…)?
There are new updates mean you have to manually approve access to images in google sheets. maybe that's what's happening! Let me know if you need any more help.
What if my range is from multiple columns? Like =SWITCH(COUNTIF(F6:F12 H6:H12 J6:J12,true),0,IMAGE(images!A1)). I've tried a few things, like commas in the range, bracketing it etc and I keep getting #ERROR
I used this to make a progession of images for when I check something off my list of Bills for the month. When I first tried, the COUNTIF function wasn't working (presumably because the image was off to the side of my chart, not aligned with the column it was pulling data from). So, to mend this issue, I did a cell with COUNTIF at the bottom of the column I was pulling from, then used VALUE in my SWITCH formula to pull whatever the number given by COUNTIF was. And it worked swimmingly. Hope this helps someone in the future.
Love the energy in your video! You're great at explaining somewhat complex subjects :)
You are amazing!
This is really great. I wasn't looking for this specific use, but the SWITCH function will probably come in very handy.
Fantastic
Thank you, looks so much fun
Hope its useful.
that was quick, thank you for this!
Hope it's helpful
This was clear and fun! thank you sir :D
Awesome to hear!
Thanks u mr, after I watching you video, I can make habits tracker more interested☺
Fantastic!
lovely!!! thank you a lot
Glad its useful!
I think I missed it if you said it, if you're using your own images, what should you do to get the url?
Use any web based images.
Thank you for this! Btw, how do you host your own photos? What methods / tools do you recommend?
I dont. Find some web based images or just a basic server or droplet from digital ocean.
Thanks for the video! I have a cell where I put a numerical "goal" and beside it a cell that shows the "actual" total of checkmarks for each column. I want to make a progression of images based on the percentage achieved of the "goal" cell. What formula should I use? Also, please put the formula for Apps Script if you're familiar with using that. Thanks!
Yes you can do that with the video formula. use IF()
bettersheets.co/formulas/if
or SWITCH()
bettersheets.co/formulas/switch
Great video! is there maybe a download link?
What do you want to download?
is there a version of this for excel?
I dont know. I use Google Sheets
If I create my own images how do I "host" them myself and give them a URL?
Maybe imgur?
this is awesome!!! I'm doing my task planner like this, but, what if instead of the specific number, i want to put a percentage of my progress? I dont have an specific number of tasks, so i'd be nice to keep track of my progress from 0% to totally done (100%) I tried to do it by myself, but it didnt work! :C
Try using IFS()
bettersheets.co/formulas/ifs
@@BetterSheets Could you please share an example of how to achieve this effect with an IFS() formula? I am struggling to get this to work. Thank you so much!
I need my tasks to be completed stage wise, like if we are on project transformation stages it should strictly tick stage wise like stage 1, tick then 2 tick, if directly my 4th stage is done by ticking on 4th stage box the earlier 1-2-3 stage should automatically get ticked. Please help me
video should be out soon: ua-cam.com/video/TIHDTuzAOD0/v-deo.html
The Tutorial is very good, is it also possible in notion?
I have no idea. I use Google Sheets.
Where can I get the proggress plant? Please anyone told me
You can use any images you want.
the images dont appear on my end. I use Google Sheets too.
What may have caused this? I already refreshed.
Getting any error?
@@BetterSheets so far, no error in terms of the image showing.
so nohting shows up and no errors. not sure from this information. I help members at bettersheets.co with any and all questions.@@MayumiMiriamGarciano
it keeps getting error for me :(
EDIT: I finally got this!!!! TYSM for your tutorial, + 1 subscribed
Glad you worked through it!
Can you please advise on what you changed? I'm also getting an error message no matter what I do :/
Same here 😅
How could we upload our own images to be used with this? I save the image and then open it in google to get a URL, but Sheets says that the URL "is not a valid url." 😿
You will have to host the images online. Can't use google drive files unfortunately.
A very quick remedy for this is to open a Google Drawing, set up your own image, and then publish from the Share menu on the Drawing. Hope that helps :)
can you share all the link of the clipart image above? Thank you
Members can get the sheet and the clipart urls.
How do you become a memeber
Maybe I have not thought this trough - but my first reaction is: why do you need „switch“ in the formula, can‘t you just do an IF X1=true, do this, else if…)?
That is a messy nested if. Some folks get confused easily with many if formulas. But sure you can do it that way.
@@BetterSheets Ah ok, I understand. I might be already insensitive to long winded IF constructs
ive done all. im use gsheet too. but in the end no images appear. meanwhile theres no more error):
There are new updates mean you have to manually approve access to images in google sheets. maybe that's what's happening! Let me know if you need any more help.
IT wont show a image. just blank
new updates mean you have to manually approve access to images in google sheets. maybe that's what's happening!
What if my range is from multiple columns? Like =SWITCH(COUNTIF(F6:F12 H6:H12 J6:J12,true),0,IMAGE(images!A1)). I've tried a few things, like commas in the range, bracketing it etc and I keep getting #ERROR
What does the error say?
use "\" instead)))
What if we keep adding muliple rows of tasks?
Depends where you add them. If inside the range, formulas should self adjust
I'm on struggle street. As soon as I add in SWITCH and the other numbers, I get #N/A :(
perhaps your switch doesn't cover all possibilities.
I dont have image function in my excel 2022. :( whatodooo?
I use Google Sheets
I did this using siferent emojis and a simple if < = >
Sweet!