Fix fields that need reformatting

Updated 15 November 2026

The Short Answer

A red box on the Prospects sheet holds words from your file that its field can't take, like TBC in a date. Open Show and pick Errors to see everyone with one, or a column's Show Errors for one column. Click a red box, put in a value that fits, and the red box goes.

Until a box is fixed its field stays empty, and your file's words wait beside it, so nothing from your file is lost.

Why is a box red?

An import fills a field only when the box is written the way the field holds it — Buy for Deal Type, 12/10/2026 for a date. Anything else, like Buyer or TBC, comes in as your file's words in a red box, and the field stays empty. Imported told you how many: 8 fields need reformatting.

Point at a red box to see why: From your file: "TBC". Isn't a date — click to reformat. The reason is one of Isn't a date, Isn't a phone number, Isn't an email address, Isn't an amount, Isn't a number, Isn't yes or no, Isn't a link or Doesn't match an option.

Move to Another Field… can leave red boxes too, when a moved value doesn't fit its new field.

How do I find them all?

  1. In the sidebar, open Prospects.
  2. Open Show above the list and pick Errors, with its count. The list keeps only people with a field to reformat. Errors is there only while you have some.
  3. For one column, press its ⌄, or right-click its heading, and choose Show Errors, with that column's count. Show Everyone takes it off.

When the last one is fixed, the list says Nothing left to reformat. Straight after an import, Show Them on the Imported screen opens the sheet on Errors for you.

Errors counts a field in a column you aren't showing too; open that person and it's on their profile.

How do I fix one on the sheet?

Click the red box once — one click, where other cells take two — and its column's own editor opens holding your file's words: a choice opens its options, a date the calendar, an amount a box to type in. The person opens beside the list too. Put in a value that fits and save; the red box goes.

A value that fits clears it whichever way it arrives: typing, Set Value ▸ on a block, Paste, Fill Down, or their profile. Clear takes your file's words away and leaves the field empty.

Undo puts both back — the field empty again and your words in the red box. See Edit many prospects at once for Undo and Redo.

Where else does a red box show?

On the person's Profile tab, the field shows the same red box with a line under it: From your file. MOP Date stays empty until this is reformatted. Press it, or its pencil, to fix it there.

Readiness, Value, Urgency and Follow-Up keep their own control, with the red box under it: pick a level or a day there and it goes.

Why can't I fix some red boxes?

A red box that can't open an editor has no click to reformat on it:

  • Do Not Call comes from the Do Not Call register, never from your words: Check this number on the Do Not Call register to clear it. The check runs when you send them a message, and its answer clears the box.
  • MOP Date is worked out from Completed On. Fix Completed On and it goes.
  • A second number or email that didn't fit is shown on the sheet only, read-only.
  • In Team view, a teammate's people draw red but open nothing, as does anyone your access doesn't let you edit.

How do I stop it happening next time?

Before your next import, write the boxes the way their fields hold them: a whole date, day first (12/10/2026 or 12 Oct 2026), one number per box, an amount like 800k or $1,200,000, a choice by its own name (Buy, not Buyer). See Import a spreadsheet of prospects for the full list.

If a whole column went into the wrong field — Last Contact dates that were really First Contact — use Move to Another Field… on its heading's ⌄. See Move a column to another field.

Still Stuck?

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