Flag a decline on a booked appointment
A declined participant doesn't cancel the booking. Keep it visible for review.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | AND(A8="booked",B8="declined") | Checks for booked with a declined response. | TRUE |
| 2 | "Review: booked but participant declined" | The message for that pair. | "Review: booked …" |
| 3 | A8&" / "&B8 | Joins the two statuses with a slash. | Not used for row 8 |
| 4 | IF( … ) | Uses part 2 when part 1 is TRUE, else part 3. | "Review: booked …" |
Capitals don't matter in the check. The booking itself is never changed.
=IF(AND(A8="booked",B8="declined"),"Review: booked but participant declined",A8&" / "&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 appointment status and the participant's response 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
Check amber rows in the source system. A decline alone doesn't mean the visit is cancelled.
Microsoft's help: Using IF with AND, OR and NOT
OTHER ROUTES YOU MIGHT LIKE

Show unassigned participant roles
Nurse, no actor → Unassigned participant role: Nurse
Get the template →
Add the patient response to the status
booked + tentative → booked; patient response=tentative
Get the template →
Put current encounter status first
finished + arrived → finished current; history excerpt=arrived
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →