Відео

Cheers! Yes that rings a bell, I think there is another comment on this. THhe latest version has =IF(Weekend_work="N",WORKDAY(J6,C6)-1,J6+C6-1) and the note in the instructions. "Please note that when a task completes a Friday night - and there is no weekend work, the system puts the completion date on a Sunday night. This is to allow the Gantt chart to calculate properly the After Date - as in fact it positions itself the day before the next working day."

@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...???

@@ProjectManagementMastery oh i see..i used excel 2010....thanks for the reply

You can still do it with embedded several IF though...

@jayprox4887 This is what Gemini gave me =IF(J11=1,"Completed",IF(ISBLANK(F11),"",IF(I11<$D$16,"Late",IF(J11=0,"Not Started","In progress"))))

@@ProjectManagementMastery Thank you so much Sir

Hi - Late is calculated based on the task deadline and today's date. Check today's date is correct.

@arndtbergmeister7375 Thanks for the tip and for the way you brought it, wish everyone was like you on the web! You are right, the Time spent vs Total work can be improved, I'm thinking more with % Completion then for a quick visual...

@joanbrodbeck3919 Wow thanks for the feedback and very well done!

Not sure what you mean...

@ShubhamYadav-nk7rh Thanks for the feedback and well done for applying it!

Thanks for the visit

Thanks for the comment. Check your email!

@ShubhamYadav-nk7rh Thanks, It is very rewarding for me to hear feedback like yours!

Thanks, I love it too but I'm biased!

That would be nice, but this would give us one of those 2 challenges: either too many tabs or external links which are often / always causing problems. Unless we have the project dashboard and the task list on one tab? In any case food for thoughts, (and while we're at it integrating the risk and issue lists!)

Glad you like them!

Thanks for the feedback :-)

Excel allows you to do things you would normally need to have a software to develop. Of course it is not perfect, specially when you do not want to have macros or VBA, but the things you can do "for free" are amazing, I find new uses everyday.

@Yun69541 Hi. I do not have it in my shop yet but I can give you what i have if you contact me here and mention you want the template 996-22 < link removed >

@moniquelevendal4704 Thank you! If you right click on the series and select Format Data series, it will give you the option to change the Gap Width...

Not sure what you mean, this is MS project!

Thank you sir!

@rashmiambale428 Hi there, I am not part of the corporate accounts, my course is only to be purchased. I have created this Free coupon for you to get it for free though.. FREEYT202405

Sometimes they don't even tell you who is interviewing so it's good practice to ask them at the beginning of the IV!

Thanks for the feedback!

Any time!

@f.ssaleh5073 A pleasure thank you!

@Sh3ll834 Thanks! If you are talking about the boards color yes you can as they are hardcoded. To group the other colors you just need to change them in the Cond formatting.

@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%

​@@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😔

​@@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😔

@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

Thanks for your comment!

@daivenotoole8300 Yes it does not look lie Excel too much

Thank you!

Thank you!

@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; ua-cam.com/video/WWFwPGqN5pI/v-deo.html

@@ProjectManagementMastery Love it! Keep me posted when its up! Great work

I hear you, I have so many template ideas in my head that I sometimes take a shortcut and don't start my demo from scratch as it takes more time. But I will keep that in mind thanks for the feedback!

No didn't get around to it yet. And I'm trying to motivate you to build it yourself!.. But it will be there soon.

@Varunrthd Hi. The template is not very well polished but if you use this link and ask for template 35, I can give you what I have. tinyurl.com/5az8kntd

Glad you liked it!

I don't think I understand your question but you can allocate a different availability over time for a specific resource.

Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome

You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.

@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?

In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.

Thanks for the feedback :-)

Thanks!

Thank you!

Thank you for your continuous support!

Thank you for the feedback!

Thank you for the feedback!

Thank you.

Thanks for the comment, please check your inbox!

Thanks for the comment! I do not have it in the shop yet

Thank you!

Thanks for the feedback!

Thank you for the feedback, appreciated!

Thanks for the visit