Resource Count & Effort Calculation
Hi there, I am struggling with two calculations, namely resource count and effort. Any assistance would be really appreciated.
For resources, I am using =COUNTM([Assigned To]@row), as there can be more than one resource per task. The problem is, this formula works at the lowest level of the task hierarchy, but it just shows 0 at the highest level. I need this formula to work in order for the effort formula to work at the highest level.
The formula I am using for effort is:
=IFERROR((Duration@row * [Resources]@row * [Resource Allocation %]@row), " "). This also works at the lowest level, but not at the highest level. It shows 0 at the highet level.
Help Article Resources
Check out the Formula Handbook template!