Respected Sir, I love the way you teach and moreover the delivery of your presentation and speech. I am blessed that i found your channel. You are such an amazing teacher. Salute to you and your hard work. Love from India
Sure! You're right currently it will spill in the 'Calc' sheet. We would need a function such as TEXTJOIN to combine the multiple activities in a single cell and stop the spill. The icons are a more difficult solution and it could be easier to dump them right now if multiple activities was wanted. Could opt for Conditional Formatting instead like I did on the full calendar sheet.
@@IvanCortinas_ES The updated version is there to be downloaded again. Maybe remove the original version from your computer. Might be a caching issue or something beyond my understanding. The new one is definitely up there though.
@@ComputergagaWhen I download the file, in cell J27 I see... =SEQUENCE(6,7,DATEVALUE(J25&K25)-WEEKDAY(J25&K25)+2) Can I see the new formula? Thank you!
@@IvanCortinas_ES The new formula is =SEQUENCE(6,7,DATEVALUE(J25&K25)-WEEKDAY(J25&K25,2)+1) This would need to be changed on both the Full Calendar sheet and the Calc sheet.
Happy New Year, Alan, and many thanks for this amazing Fitness-Tracker tutorial/video!
Thank you, Colin
Respected Sir,
I love the way you teach and moreover the delivery of your presentation and speech. I am blessed that i found your channel. You are such an amazing teacher. Salute to you and your hard work.
Love from India
Thanks a million for this, Alan. Yet another of your little gems.
I take this opportunity to wish you a very prosperous year!
Thanks Giorgio. Wishing you a healthy and happy 2025.
I love it, thank you for doing this.
@@BeataWaite my pleasure 💪
Is there any way to amend the tracker to allow for multiple activities in the same day? Currently this leads to a Spill error
Sure! You're right currently it will spill in the 'Calc' sheet. We would need a function such as TEXTJOIN to combine the multiple activities in a single cell and stop the spill.
The icons are a more difficult solution and it could be easier to dump them right now if multiple activities was wanted. Could opt for Conditional Formatting instead like I did on the full calendar sheet.
Thabks! @@Computergaga
June 1, 2025 does not appear on the calendar.
What happened?
Good spot, Ivan. I've updated the template.
@@Computergaga I still don't see June 1st.
@@IvanCortinas_ES The updated version is there to be downloaded again.
Maybe remove the original version from your computer. Might be a caching issue or something beyond my understanding. The new one is definitely up there though.
@@ComputergagaWhen I download the file, in cell J27 I see...
=SEQUENCE(6,7,DATEVALUE(J25&K25)-WEEKDAY(J25&K25)+2)
Can I see the new formula?
Thank you!
@@IvanCortinas_ES The new formula is =SEQUENCE(6,7,DATEVALUE(J25&K25)-WEEKDAY(J25&K25,2)+1)
This would need to be changed on both the Full Calendar sheet and the Calc sheet.