How To Make That Viral Growing Plant Progress Chart (Money Plant)

Подписаться 6 тыс.

Просмотров 19 тыс.

50% 1

You might have seen a viral TikTok where there is a progress bar and a growing sort of garden of flowers or potted plant that's growing as you check off these task bars tasks. So I want to walk through what this formula, the combination is how it's really cool it
🔔 Subscribe for more free Google Sheets tips: ru-vid.com?...
🕰️ Time Saving Tips, Tricks and Techniques
bettersheets.co/topics
🤖 Add AI to Your Sheets
bettersheets.co/courses/adven...
🚀 Tools and Templates For YOU:
Generate Google Sheets Formulas:
bettersheets.co/google-sheets...
100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.
Free at bettersheets.co/tools/100-bus...
Tiny Sheets - Easily delete unnecessary rows and columns
Free Add-on: tinysheets.bettersheets.co/
Sheet Styles - Change your spreadsheets style to match your mood.
Get it now: sheet-styles.bettersheets.co/
Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.
30 free: atomicsheets.com/
Generate REGEXMATCH formulas to clean data
bettersheets.co/regexmatcher
Generate SPARKLINE formulas to make cool charts inside of cells.
bettersheets.co/sparkliner
😎 Most Popular Tips and Tricks
Extract Urls from Google Sheets
blog.bettersheets.co/extract-...
⚙️Automate Your Sheets:
Spreadsheet Automation 101, get started making your sheets work for you, while you sleep
Start Automating: bettersheets.co/courses/sprea...
Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!
Learn here: www.udemy.com/course/learn-to...
📺Step-by-Step Tutorials
Find EVERYTHING you need to make your spreadsheets better on my website BetterSheets.co
Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 62

@skye8274 Год назад

that was quick, thank you for this!

@BetterSheets Год назад

Hope it's helpful

@chubikiut579 4 месяца назад

This was clear and fun! thank you sir :D

@BetterSheets 3 месяца назад

Awesome to hear!

@peace.n.blessings5579 5 месяцев назад

Thank you, looks so much fun

@BetterSheets 5 месяцев назад

Hope its useful.

@angelaavaoracle8183 Год назад

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

@BetterSheets Год назад

You are amazing!

@dirknoom4389 6 месяцев назад

This is really great. I wasn't looking for this specific use, but the SWITCH function will probably come in very handy.

@BetterSheets 6 месяцев назад

Fantastic

@littlekrabbie7585 9 месяцев назад

lovely!!! thank you a lot

@BetterSheets 6 месяцев назад

Glad its useful!

@marieskuby7643 8 месяцев назад

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.

@pinkcohort 12 дней назад

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!

@macbp41 3 месяца назад

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.

@CozyWithRaven 8 месяцев назад

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.

@karlaceballos5502 Год назад

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!

@annikalachner6520 11 месяцев назад

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

@BetterSheets 11 месяцев назад

I have no idea. I use Google Sheets.

@aidanparente2046 5 месяцев назад

Great video! is there maybe a download link?

@BetterSheets 5 месяцев назад

What do you want to download?

@CarlyBlack-teach 28 дней назад

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

@BetterSheets 28 дней назад

Maybe imgur?

@sailinaik2786 4 месяца назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-TIHDTuzAOD0.html

@leemathews671 Год назад

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

@yeojinsfrog2182 Год назад

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 😅

@rosiehall6764 Год назад

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 11 месяцев назад

use "\" instead)))

@user-up7up1ki2g Год назад

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

@BetterSheets Год назад

Members can get the sheet and the clipart urls.

@samantharogers8219 28 дней назад

How do you become a memeber

@nabilchoironnaim5248 2 дня назад

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

@BetterSheets День назад

You can use any images you want.

@mattchannel7075 Год назад

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

@designspurtstudio1014 Год назад

What if we keep adding muliple rows of tasks?

@BetterSheets Год назад

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

@emirmikhail6342 5 месяцев назад

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.