Duration formula tied to allocation percentage
I am trying to create the correct formula tied to the percentage allocated for each task for the full duration
For example the total task has a duration of 54 Days. The Create task allocated .75 of the total duration (which is the same cell for each task) but I am not sure what formula should be put in the allocation duration cell. I tried different formulas(=Alloc.@row *[Duration]37; =Value([Alloc.]@row) * Value([Duration]@37]) and nothing worked. .75 of the total 54 days(this is in the Duration cell Row 37 should = 40.5. Thanks in advance for the formula help...I feel like it is simple but can't get it to work and need this formula for 150 different batches
Help Article Resources
Check out the Formula Handbook template!