Count number of resources assigned and display the resource allocation%

Jean Kim

Is there a way to:

(1) count the number of resources in the [Assigned To]

(2) duplicate the allocation % based on the number of resources counted from the [Assigned To]

Please see example below.

Thanks.

Jean Kim

It's working with the following.

=IF(Type80 = 1, JOIN([Planned Hrs]80 + "| " ), IF(Type80 = 2, JOIN([Planned Hrs]80 + "| " + [Planned Hrs]80), IF(Type80 = 3, JOIN([Planned Hrs]80 + "| " + [Planned Hrs]80+ "| " + [Planned Hrs]80))))

Case closed.

Jean Kim

Something like this in excel.

Jean Kim

Explored some formula with IF and Join, It works when it's one scenario, but it doesnt seem to work when its for multiple scenarios. =(

=IF(([# of resources]82) = 1, JOIN(([Hrs allocated]82 + "| "))). -> works

=IF(([# of resources]81) = 2, JOIN(([Hrs allocated]81 + "| " + [Hrs allocated]81))) -> works

=IF(([# of resources]83) = 3, JOIN(([Hrs allocated]83 + "| " + [Hrs allocated]83 + "| " + [Hrs allocated]83))) -> works

=IF((Type80) = 1, JOIN(([Planned Hrs]80 + "| " ))), IF((Type80) = 2, JOIN(([Planned Hrs]80 + "| " + [Planned Hrs]80))), IF((Type80) = 3, JOIN(([Planned Hrs]80 + "| " + [Planned Hrs]80+ "| " + [Planned Hrs]80))). -> doesnt work.

Jean Kim

It's working with the following.

=IF(Type80 = 1, JOIN([Planned Hrs]80 + "| " ), IF(Type80 = 2, JOIN([Planned Hrs]80 + "| " + [Planned Hrs]80), IF(Type80 = 3, JOIN([Planned Hrs]80 + "| " + [Planned Hrs]80+ "| " + [Planned Hrs]80))))

Case closed.

Hanzari Phang

👍️

Andrée Starå

Hi @Jean Kim

Glad you got it working!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!