Put current encounter status first

The last history row isn't the current state. Show both, current first.

What you'll make

In Excel: finished + arrived becomes finished current; history excerpt=arrived.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8=""Checks whether the current status is empty.FALSE
2A8&" current; history excerpt="&Writes the current status, then the history label."finished current; …"
3IF(B8="","not supplied",B8)Adds the history status, or not supplied."… excerpt=arrived"
4IF( … )Flags a missing current status, else uses parts 2 and 3."finished current; …"

Read it left to right. The current status always comes first. Nothing is judged from the history.

=IF(A8="","Review missing current encounter status",A8&" current; history excerpt="&IF(B8="","not supplied",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 list. Paste each encounter's current status and its history status into the green columns of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Take the current status from the latest version of the encounter, not the last history row.

Microsoft's help: IF function