◆ Excel · formulas

Data Linking

Link survey metadata, photos, and legal parcel IDs across sheets so each map feature row on Features shows its source …

2heights
2tasks
1roles do it

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Link survey metadata, photos, and legal parcel IDs across sheets so each map feature row on…+
Link survey metadata, photos, and legal parcel IDs across sheets so each map feature row on Features shows its source document links and parcel ID on review; ensure links update when filenames change.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Make the feature row defensible for the legal reviewer: add named ranges for key ID fields,…+
Make the feature row defensible for the legal reviewer: add named ranges for key ID fields, display thumbnail filenames and a hyperlinked path to the photo and survey note, include last-updated user/timestamp, and add a small Audit column showing which sheet provided the primary source.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Link survey metadata, photos, and legal parcel IDs across sheets so a map feature always shows its source documents on review.

Who does this

1 roles
Cartographer

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.