Put current encounter status first
The last history row isn't the current state. Show both, current first.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the current status is empty. | FALSE |
| 2 | A8&" current; history excerpt="& | Writes the current status, then the history label. | "finished current; …" |
| 3 | IF(B8="","not supplied",B8) | Adds the history status, or not supplied. | "… excerpt=arrived" |
| 4 | IF( … ) | 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.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own list. Paste each encounter's current status and its history status into the green columns of the Template tab.
- 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
OTHER ROUTES YOU MIGHT LIKE

Label locations by encounter status
reserved, Bed 4A → Reserved location: Bed 4A
Get the template →
Label pre-admission and encounter IDs
P451 + V208 → Pre-admission ID: P451; encounter ID: V208
Get the template →
Label a contact value with its type
phone + 201-555-0123 → phone: 201-555-0123
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →