Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
Progress tracker with animated image in Google Sheet - Excel Tips and Tricks
24 Views • Jul 22, 2025
Description
I will not be using an animated gif in cell, but use logical IF to shuffle the image. I will be using checkbox to replace traditional progress bar for project tracking and habit tracking. Did I day this can be used for habit tracking too?
Here are the steps as outlined on this video.
Add Checkboxes
1) Highlight A2 to A21
2) Insert ~ Checkbox
Calculations
1) Count completed task
=COUNTIF(B2:B21,TRUE)
2) Count incomplete task
=COUNTIF(B2:B21,FALSE)
3) Percentage completed
=B25/SUM(B25:B26)
Image Repo
1) New Sheet
2) Select A1
3) Insert ~ Image ~ Insert image in cell
4) Upload tab
5) Browse
6) Select your picture
7) Open
8) Do for the remaining of the images.
Repeat steps 2 to 7
9) Resize cell height (153px)
Growth Image
1) Select Cell B23
2) =IF(B27=1,'159_IMG'!E1,"")))))
Note these are my boundaries
=1
3) Resize row 23 height
google sheets animated gif in cell,google sheets progress bar checkbox,google sheets animated chart,google sheets progress bar with text,
progress tracker with animated image in google sheet free,progress tracker with animated image in google sheet app,google sheets animated gif in cell,google sheets progress tracker template,google sheets progress bar checkbox,google sheets animated chart,animate chart in google slides,google sheets progress bar with text,
More from User
I Created a FILTER() Function For Excel 2016 and Older Versions - Excel Tips and Tricks
ExcelTips247
DELETE rows in Excel without affecting other rows - Excel Tips and Tricks
ExcelTips247
I Created a UNIQUE() Function For Excel 2016 and Older Versions - Excel Tips and Tricks
ExcelTips247
Compare Two Tables In Excel - Excel Tips and Tricks
ExcelTips247
TOCOL and TOROW Functions in Excel - Excel Tips and Tricks
ExcelTips247
I Created a XLOOKUP() Function For Excel 2016 and Older Versions - Excel Tips and Tricks
ExcelTips247
Related Videos
Progress tracker with animated image in Excel - Excel Tips and Tricks
ExcelTips247
Habit Tracker Template in Google Sheets - Excel Tips and Tricks
ExcelTips247
Track Project Progress Using SPARKLINES and COUNTIF in Google Sheet - Excel Tips and Tricks
ExcelTips247
Excel Tips and Tricks - Online Attendance Sheet With Checkbox In Google Sheet
ExcelTips247
Why is Drop Down List in Google Sheet better than in Excel - Excel Tips and Tricks
ExcelTips247
Quick and Easy Way to Add Multiple rows and column in Excel and Google Sheets - Excel Tips and Tricks
ExcelTips247