Тёмный

Upgraded Automatic Task Tracker In Excel with VBA Automation 

sheetsbyolan
Подписаться 1 тыс.
Просмотров 1,6 тыс.
50% 1

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

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 27   
@jacquelynbosco3746
@jacquelynbosco3746 4 дня назад
i am also unable to get the completed counter formula to accept. i have tried for hours and can't seem to locate the issue. any advice
@Crayhunter99
@Crayhunter99 Месяц назад
This thing awesome. I'm excited to start tracking my life. I noticed that when you deleted row 1 from the Parked and Done tab, I kept getting a circular reference error any time a row is moved from Task List to the Done tab. I fixed it just but adding back an empty row to Done and Parked tab. Not a big deal for me.
@weiredreject
@weiredreject Месяц назад
I cant seem to get the completed number to update when i change/ enter information. When i entered a date in the done sheet it went up but not on the task list sheet
@Yeahnoyeahuhhu
@Yeahnoyeahuhhu Месяц назад
Same here and can’t for the life of me figure out why lol
@sheetsbyolan
@sheetsbyolan Месяц назад
@@weiredreject if you want to email me a screenshot of your formula I can help troubleshoot
@sheetsbyolan
@sheetsbyolan Месяц назад
@@Yeahnoyeahuhhu if you want to email me a screenshot of your formula I can help troubleshoot . Sheetsbyolan@gmail.com
@cuddlesmcgee9056
@cuddlesmcgee9056 26 дней назад
The time stamps are only working on some lines. Does anyone know why?
@sheetsbyolan
@sheetsbyolan 19 дней назад
They'll only trigger if you manually select the option. If you use the fill handle, it may not trigger as an edit. That could be a reason
@cuddlesmcgee9056
@cuddlesmcgee9056 19 дней назад
@@sheetsbyolan thanks
@BibblyJibbly
@BibblyJibbly Месяц назад
There may be really obvious answer to this question, but I'm going to ask it anyway, can you explain what your intention for "PARKED" is/was so I can better understand how to use it? Thank you!
@sheetsbyolan
@sheetsbyolan Месяц назад
@@BibblyJibbly parked is for the tasks that you can’t work yet due to time constraints or you’re waiting on someone else to complete their part. That way you can keep the task in mind but it’s not cluttering up your active task list
@leeannmanning7583
@leeannmanning7583 25 дней назад
When I am updating something to 'done' under progress/status it is not moving to the done tab. Any thoughts?
@sheetsbyolan
@sheetsbyolan 19 дней назад
It sounds like either Recurring is the priority or the VBA code isn't enabled fully. You may need to force run the VBA code to jump start it.
@StefaniaGutierrez-e6f
@StefaniaGutierrez-e6f Месяц назад
for some reason once its parked I can't get it to move back to the task list? either using ready or pending?
@sheetsbyolan
@sheetsbyolan Месяц назад
Hey! I think there was an error with the code linked for some people. I’ve updated it on my GitHub. If it doesn’t work still, email me and I can send over the template
@gd4628
@gd4628 Месяц назад
Beautiful!!! Any advice for someone that has zero experience but wants to learn these in excel
@sheetsbyolan
@sheetsbyolan Месяц назад
@@gd4628 watch videos on social to get introduced to concepts. You don’t know something is possible until you see it for the first time. Then practice by taking online classes. If you have a favorite creator that has a course and want to buy from them that’s great. There are a ton of free courses though and if you have a library card a lot of them allow access to LinkedIn learning for free!
@s0urfru1t
@s0urfru1t Месяц назад
Hi! I’m having a couple issues. 1. The completed counter only updates if the task is recurring. 2. The task isn’t moved into the “Parked” tab 3. When I run the code a tab appears that doesn’t for you.
@sheetsbyolan
@sheetsbyolan Месяц назад
@@s0urfru1t hey! 1) The completed counter will only reflect done non recurring tasks if they’re on the done tab. The task completed date also needs to be within 7 days of the start date listed on the task list. Is that the case? 2) are the timestamps being added and the tasks moving to the done tab? It could be that the automation isn’t live. 3) What tab appears?
@fliufau
@fliufau Месяц назад
Were you able to get #2 resolved? I can't get any of my tasks to move to the parked or done tabs
@moxxyj
@moxxyj Месяц назад
Everything about the automation and timestamps works fine but when tasks are moved to the Parked tab, even when the status is changed to Pending, it stays in the Parked tab and does not move back to the Task List. Same issue for the Done tab.
@sheetsbyolan
@sheetsbyolan Месяц назад
Hey! The trigger for moving a task from the parked tab to the task list is “Ready”. Can you try selecting that to see if the automation works?
@monkeyf1uff757
@monkeyf1uff757 Месяц назад
@@sheetsbyolan I'm having the same issue even selecting ready it stays on the parked tab
@smithbryanw1
@smithbryanw1 Месяц назад
Same here. I chamged list to “ready” like @sheetsbyolan said and still no change.
@sheetsbyolan
@sheetsbyolan Месяц назад
@@monkeyf1uff757 I see you put "ready" instead of "Ready". Can you confirm the dropdown option is capitalized correctly?
@sheetsbyolan
@sheetsbyolan Месяц назад
@@smithbryanw1 I see you put "ready" instead of "Ready". Can you confirm the dropdown option is capitalized correctly?
Далее
EASILY Make an Automated Data Entry Form in Excel
14:52
50m Small Bike vs Car FastChallenge
00:22
Просмотров 3 млн
КВН 2024 Встреча выпускников
2:00:41
Highlight Active Row & Column in Excel (7 Levels)
22:56
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
How to Move Data Automatically Between Excel Files
11:37
50m Small Bike vs Car FastChallenge
00:22
Просмотров 3 млн