Move a column to another field

Updated 15 November 2026

The Short Answer

In Prospects, open a column's ⌄ and choose Move to Another Field…. Pick the field under Move to, check the preview and press Move 9 Values (your count). Every value moves exactly as written, for everyone shown on the sheet; the old field is left empty, and Undo puts it all back.

It's the fix for a column that went into the wrong field — Last Contact dates that were really First Contact.

How do I move a column?

  1. In Prospects, filter or search the list down to the people you want moved — the move covers everyone shown.
  2. Press the column's ⌄, or right-click its heading, and choose Move to Another Field….
  3. Move Last Contact to Another Field opens. Under Move to, pick the field — the same groups as an import, Contact, The Lead, What They Want and Their Home, or More Fields… for any other.
  4. Check the preview, then press Move 9 Values — the button carries the count. Cancel changes nothing.

The rows change in place on the sheet. Your next import remembers it too: a heading you had put into the old field now goes into the new one.

What does the preview show?

A table of one row per person: Name, the old field and the new one, 50 at a time. Show 50 More loads the next, and says how many are left.

A value that won't fit its new field is a red box; point at it: Isn't a date — it'll still be moved, and you can reformat it afterwards.

Under the table:

  • Every value fits First Contact. — or 2 fields need reformatting in First Contact. They'll still be moved, and you can reformat them afterwards.
  • Last Contact will be left empty. 3 people already have a First Contact, which will be replaced. You can undo this from the sheet.

What happens to each value?

  • Exactly as written, never translated. A date moves as its day (12 Oct 2026), an amount as $1,600,000, a choice as its name. The new field takes it only if it's written the way it holds values.
  • Doesn't fit: it still moves, as a red box holding the words, with the new field empty. See Fix fields that need reformatting.
  • The old field is left empty. A red box in it moves along too.
  • A value already in the new field is replaced.
  • Into Notes: each value is added as a line under what's there, such as Last Contact: TBC; nothing in Notes is replaced.

Who does it move?

Everyone shown on the sheet: the list as your Show filter, column filters and search leave it, across every page, not only the page on screen. To move only some people, filter first.

The sheet holds up to 500 people at a time; anyone past that isn't moved.

Someone whose new field can't take a value — Current Rent for a person with no home on file — is left as they were, and the sheet says afterwards: 2 values couldn't be moved.

Can I undo a move?

Yes. The sheet's Undo puts the whole move back as one step — both fields for every person, and any red boxes. Redo does it again. See Edit many prospects at once.

A move into Readiness, Value or Urgency counts as setting it, the same as an edit on the sheet: a group a rule fills, or a campaign that starts from it, follows the new value, and Undo doesn't take those back.

Why isn't Move to Another Field offered?

Move to Another Field… shows only on a column whose values can move, in your own book — not in Team view — and only with Full Access in Prospects.

Never moved, in or out: Do Not Call, consent and unsubscribed — they decide whether you may message someone. Also not moved: Mobile, Email and the other numbers and emails (the ones your messages go to), Name, To Find Out, fields PropKaki works out such as MOP Date, and PropKaki's own columns. Follow-Up can take a move but not give one, so its note isn't lost.

A field from More Fields… that Move can't write says Values can't be moved into this field.

Still Stuck?

Ask PropKaki in the chat — it answers most of these directly — or message the team.