Love the energy in your video! You're great at explaining somewhat complex subjects :)

@BetterSheets

Жыл бұрын

You are amazing!

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 really great. I wasn't looking for this specific use, but the SWITCH function will probably come in very handy.

@BetterSheets

7 ай бұрын

Fantastic

This was clear and fun! thank you sir :D

@BetterSheets

4 ай бұрын

Awesome to hear!

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.

that was quick, thank you for this!

@BetterSheets

Жыл бұрын

Hope it's helpful

Thank you, looks so much fun

@BetterSheets

5 ай бұрын

Hope its useful.

lovely!!! thank you a lot

@BetterSheets

6 ай бұрын

Glad its useful!

Thank you for this! Btw, how do you host your own photos? What methods / tools do you recommend?

@BetterSheets

3 ай бұрын

I dont. Find some web based images or just a basic server or droplet from digital ocean.

The Tutorial is very good, is it also possible in notion?

@BetterSheets

11 ай бұрын

I have no idea. I use Google Sheets.

Great video! is there maybe a download link?

@BetterSheets

5 ай бұрын

What do you want to download?

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

Жыл бұрын

Try using IFS() bettersheets.co/formulas/ifs

@colleensullivan3423

11 ай бұрын

@@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 think I missed it if you said it, if you're using your own images, what should you do to get the url?

@BetterSheets

8 ай бұрын

Use any web based images.

it keeps getting error for me :( EDIT: I finally got this!!!! TYSM for your tutorial, + 1 subscribed

@BetterSheets

Жыл бұрын

Glad you worked through it!

@tziporahgoldblatt

11 ай бұрын

Can you please advise on what you changed? I'm also getting an error message no matter what I do :/

@wiscogirl3

Ай бұрын

Same here 😅

If I create my own images how do I "host" them myself and give them a URL?

@BetterSheets

Ай бұрын

Maybe imgur?

Where can I get the proggress plant? Please anyone told me

@BetterSheets

3 күн бұрын

You can use any images you want.

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

@BetterSheets

3 ай бұрын

video should be out soon: kzread.info/dash/bejne/hn18prauqqS1dJM.html

can you share all the link of the clipart image above? Thank you

@BetterSheets

Жыл бұрын

Members can get the sheet and the clipart urls.

@samantharogers8219

Ай бұрын

How do you become a memeber

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

@BetterSheets

Жыл бұрын

You will have to host the images online. Can't use google drive files unfortunately.

@marieskuby7643

8 ай бұрын

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 :)

ive done all. im use gsheet too. but in the end no images appear. meanwhile theres no more error):

@BetterSheets

4 ай бұрын

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 we keep adding muliple rows of tasks?

@BetterSheets

Жыл бұрын

Depends where you add them. If inside the range, formulas should self adjust

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

@BetterSheets

Жыл бұрын

That is a messy nested if. Some folks get confused easily with many if formulas. But sure you can do it that way.

@mattchannel7075

Жыл бұрын

@@BetterSheets Ah ok, I understand. I might be already insensitive to long winded IF constructs

the images dont appear on my end. I use Google Sheets too. What may have caused this? I already refreshed.

@BetterSheets

11 ай бұрын

Getting any error?

@user-bf8xn1un9i

11 ай бұрын

@@BetterSheets so far, no error in terms of the image showing.

@BetterSheets

11 ай бұрын

so nohting shows up and no errors. not sure from this information. I help members at bettersheets.co with any and all questions.@@user-bf8xn1un9i

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

@BetterSheets

Жыл бұрын

What does the error say?

@irynasiavavko6547

Жыл бұрын

use "\" instead)))

I dont have image function in my excel 2022. :( whatodooo?

@BetterSheets

Жыл бұрын

I use Google Sheets

IT wont show a image. just blank

@BetterSheets

4 ай бұрын

new updates mean you have to manually approve access to images in google sheets. maybe that's what's happening!

I'm on struggle street. As soon as I add in SWITCH and the other numbers, I get #N/A :(

@BetterSheets

5 ай бұрын

perhaps your switch doesn't cover all possibilities.