Show unassigned participant roles

A Nurse role with no person yet stays on the list as an unassigned role.

What you'll make

In Excel: Nurse, no actor becomes Unassigned participant role: Nurse.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1AND(A8="",B8="")Checks whether both cells are empty.FALSE
2"Unassigned … "&A8With no person, labels the role as unassigned."Unassigned … Nurse"
3B8With a person, uses that person's reference.Not used for row 8
4IF( … )Picks the review note, the label or the person."Unassigned … Nurse"

Both cells empty says Review participant missing role and actor. In the Template that row stays blank.

=IF(AND(A8="",B8=""),"Review participant missing role and actor",IF(B8="","Unassigned participant role: "&A8,B8))

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own participants. Paste each participant's role and actor reference into the green columns of the Template tab. Leave the actor empty when nobody is assigned yet.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

A role with nobody assigned is kept on purpose. Assign the person in your scheduling system, not here.