Keep task status beside business state
A local label like Awaiting auth never replaces on-hold or completed. Show both.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | Takes the standard task state. | "on-hold" |
| 2 | &"; business state="& | Adds a semicolon and the words business state. | "on-hold; … state=" |
| 3 | IF(B8="","not supplied",B8) | Adds the business state, or not supplied. | "… =Awaiting auth" |
Read it left to right. Each & joins the next piece on. The local label never stands in for the task state.
=A8&"; business state="&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 task state and its business state 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
Business labels differ between workflows. Check what yours means before acting on it.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Label the assigned task owner
Ava Reed → Assigned owner: Ava Reed
Get the template →
Label referral request links by role
replaces, SR-101 → Replacement of prior request: SR-101
Get the template →
Keep requester and performer apart
Ava Reed + ENT → Requester: Ava Reed; requested performer: ENT
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →