Label the assigned task owner

Show who owns each task, never the requester or the patient it's for.

What you'll make

In Excel: Ava Reed becomes Assigned owner: Ava Reed.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8<>""Checks if the task has an owner.TRUE
2"Assigned owner: "&A8Puts the label in front of the owner."… owner: Ava Reed"
3"Owner unassigned; …"Says no owner is set yet.Not used for row 8
4IF( … )Uses part 2 when there's an owner, else part 3."… owner: Ava Reed"

Read it left to right. The Template stays blank until you paste an owner.

=IF(A8<>"","Assigned owner: "&A8,"Owner unassigned; do not substitute requester or beneficiary")

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 list. Paste each task's owner into the green column of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Leave the owner blank when none is set. Don't fill it with the requester or the patient.

Microsoft's help: IF function