Simplecty is the key, Very useful video thank you sir
@ProjectManagementMastery7 ай бұрын
Thanks for the feedback.
@selambelachew560216 күн бұрын
followed the tutorial, done it and I like it. Thanks
@ProjectManagementMastery16 күн бұрын
Great job! I'm glad you made sense of my rambling!
@shameless83br11 ай бұрын
This is really good and simple task tracker with insightful dashboard. Thanks a lot.
@ProjectManagementMastery11 ай бұрын
Thanks for the feedback!
@oscareduardogonzalezgonzal491510 ай бұрын
Great class, very detailed and easey to follow!
@ProjectManagementMastery10 ай бұрын
Great to hear!
@malikassouf4527 Жыл бұрын
Thank you, that will be soooo useful 🙂
@brendanmcnally30237 ай бұрын
This is what i was looking for
@Luuvvsy5 ай бұрын
Very good
@ProjectManagementMastery5 ай бұрын
Thanks
@user-is6nn2ti7w9 ай бұрын
Very useful for me. thank you so much
@ProjectManagementMastery9 ай бұрын
Thanks for the feedback - always appreciated!
@user-hz5xw5ri8i6 ай бұрын
Wow amazing
@ProjectManagementMastery6 ай бұрын
Thanks a lot 😊
@divad1214ify4 ай бұрын
I'm curious what this would look like if you wanted to include multiple projects on the same tab with core tasks tracked below each project. I'm always on the lookout for a dashboard that allows for a higher level of project tracking that still allows me to capture some key tasks under each project. Love this tutorial!
@ProjectManagementMastery4 ай бұрын
@divad1214ify You must be a medium of some sorts, I have a Program Dashboard coming up next week that works on a high level picking up data from a Project Dashboards like this one; kzfaq.info/get/bejne/jb12qrN41rSZoH0.html
@divad1214ify4 ай бұрын
@@ProjectManagementMastery Love it! Keep me posted when its up! Great work
@dineshbalagam56498 ай бұрын
Thank you its very useful
@ProjectManagementMastery8 ай бұрын
Thank you for your comment!
@udokaugorji730410 ай бұрын
Awesome!!
@ProjectManagementMastery10 ай бұрын
Thanks!
@Vishwesh2680Ай бұрын
Thank you sir, very good insight. I am wondering how did you get Late value. I have added the formula, however it seems Late is not coming up
@ProjectManagementMasteryАй бұрын
Hi - Late is calculated based on the task deadline and today's date. Check today's date is correct.
@juragan882111 ай бұрын
Nice🎉🎉
@hanisalehal-ssenai14317 ай бұрын
Greet
@divya111526 күн бұрын
I am trying to ge the work left populated as guided by you, bit its not just happening, not sure where Am I going wrong 😢
@ProjectManagementMastery26 күн бұрын
Hi - It's hard to assess without seeing hat you're doing but the work left is (total work) less (total work * Completion %) =H12-(H12*J12)...
@aishaabubakar435711 ай бұрын
this very good tracker for a project. if I wanted to include a descoped status when there is no value in column " J" how do I write the IF function for that?
@ProjectManagementMastery11 ай бұрын
Thanks for the feedback. I am not sure what you mean but if you need to create another status for code, you would need another field to refer to - or maybe put something specific in the resource like "NR" and then use this in your status field as a an additional IF...
@aishaabubakar435711 ай бұрын
Do you by any chance teach one on one? @@ProjectManagementMastery
@ProjectManagementMastery11 ай бұрын
I don't really but if you tell me what you need I'll see what I can do.
@aishaabubakar435710 ай бұрын
I am having issues with including a new row to count blank cells within the completed column on the dashboard of your template@@ProjectManagementMastery
@ProjectManagementMastery10 ай бұрын
Just make sure you are also increasing the size of the named field "Task_Name" and "Completion" in the name manager section. It should increase automatically when you insert rows within the table.
@agapenilo43754 ай бұрын
This is a great tutorial, however, i got lost when you started the Calculation sheet, and entered the calculations, (timestamp 29:59 - 30:04, i tried understanding it but i was unable to, may you please help with that?😢😢
@ProjectManagementMastery4 ай бұрын
@agapenilo4375 You ask so nicely it's hard to say no. I think you are referring to this formula? "=COUNTIFS(Task_name,"""",Completion,"=0")" In this I check 2 things, first that there is no blank ("") in the task column, meaning we have a task in there, and there is another condition is that the task has not started, which translates into Completion% = 0%
@agapenilo43754 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@agapenilo43754 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@ProjectManagementMastery4 ай бұрын
@agapenilo4375 I know it can be frustrating when we see a problem like this. If you want to email me what you have here, or if you get in touch I can send you a sample
@jayprox4887Ай бұрын
Hi, I follow as per your video and have error (#name?). =IFS(J11=1,"Completed",ISBLANK(F11),"",I110,"In progress") Please help😃
@ProjectManagementMasteryАй бұрын
@jayprox4887 Hi! Well that's odd, I just copied that in a blank excel and it works... Are you sure you have a recent version of Excel that can use IFS...???
@jayprox4887Ай бұрын
@@ProjectManagementMastery oh i see..i used excel 2010....thanks for the reply
@ProjectManagementMasteryАй бұрын
You can still do it with embedded several IF though...
@ProjectManagementMasteryАй бұрын
@jayprox4887 This is what Gemini gave me =IF(J11=1,"Completed",IF(ISBLANK(F11),"",IF(I11
@jayprox488728 күн бұрын
@@ProjectManagementMastery Thank you so much Sir
@HezekaiahBBagita-dd8wb6 ай бұрын
Why are there still days in red when task is completed?
@ProjectManagementMastery6 ай бұрын
Don;t know what you mean
@mariamagandi37777 ай бұрын
Thank you for this beautiful video; it really helpful. I'm getting an error (#Name?) in the calculation for the Not Started; as a result, I can't proceed further. Maybe I'm missing a step before that. Thank you.
@ProjectManagementMastery7 ай бұрын
Thanks for the comment. Are you using the template? If not I suggest you request for it and you compare with your version. As there is no defined name in that field I'll assume there is a typo in your formula? Compare with this : "=IFS(J12=1,"Completed",ISBLANK(F12),"",I120,"In progress")"
@mariamagandi37777 ай бұрын
@ProjectManagementMastery. Please, how to request for it?
@ProjectManagementMastery7 ай бұрын
Not having a go at you but I am still surprised people don't check in the description before asking how to get the template! You're not the only one dont worry :-)
@mariamagandi37777 ай бұрын
@ProjectManagementMastery . Sorry for being a pain. I've sent the template request. Thank you 😊
@retro18537 ай бұрын
@@ProjectManagementMastery hi sir, I have MS Excel 2013 version, you said that some macros are required if this IFS function is not available in older version, can you help with this. I am not able to proceed further.
@OurShortsAreScary6 ай бұрын
i am not getting the template when i signed up on your template link?
@ProjectManagementMastery6 ай бұрын
@OurShortsAreScary If you don't have it it's one of those: 1. You did not ask nicely :-) 2. You did not wait long enough 3. You provided a wrong email address
@hanzelmalasaga3122Ай бұрын
I did not get the work required and the work left huhu