Search, sort and filter your prospects
Updated 18 November 2026
The Short Answer
In Prospects → Individuals, Search looks through every column's words — or one column, picked from All Columns ▾. Press a column's heading to sort by it, or its ⌄ for its sorts — Hot First on Readiness — and a checklist to filter by. Blanks always sort last. Customise picks your columns.
Each column's panel works like Excel's: its two sorts at the top, then a checklist of the values on the page.
Which columns does Individuals show?
Until you choose your own, Prospects → Individuals shows: Name, Urgency, Readiness, Value, Groups, Follow-Up, Deal Type, Property Type, Budget (Maximum), Locations, Lead Source, Goes By, Last Reply and To Find Out — 14 in all.
- Press Customise above the list. Customise Columns opens.
- Tick the columns you want and untick the rest; drag them in the list on the right to change their order.
- Press Save. Reset puts the default back.
If you saved your own columns before, you keep them, with To Find Out added at the end. Urgency, To-Dos and Groups are under Where They Stand in Customise Columns. To-Dos sorts by each person's next to-do day, and its filter offers Has a To-Do Due and Has a To-Do.
Point at a heading to read what the column means — Groups says The groups they're in.
How do I search my prospects?
Type in Search above the list on Individuals. It looks through every column that holds words:
- their name, the name you renamed them to, and Goes By
- their phone numbers and emails
- your Notes
- the names of the groups you put them in by hand — a group you fill yourself, or a group with a rule you added them to (people a rule brings in are found by the detail itself: warm finds everyone Warm)
- every profile detail held as words — Deal Type, Property Type, Locations, Lead Source, Readiness, Value, Urgency, Timeline and the rest
How it reads what you type:
- Words match in any order, and each one must be there: lead $1 finds $1 lead.
- Symbols count: $1 finds $1, not every phone number with a 1 in it.
- A word of four letters or more ending in s also finds it without the s: leads finds lead.
- Figures and dates — Budget, Follow-Up, Last Reply — aren't searched. Use their column's filter (below).
- Three or more digits on their own search phone numbers only.
Select all, on the band once you've ticked someone, ticks everyone the list shows on every page: after a search, exactly the people it found, and with a column filter, only the people it keeps. It takes up to 500 at a time; past that it ticks the first 500 in your order and says the first 500. Anyone you ticked yourself on another page stays ticked.
How do I search just one column?
- Press All Columns ▾ at the left of the search box.
- Pick a column — the columns on your sheet that hold words, such as Name, Groups, Property Type, Locations or Goes By.
- Type. The chip turns blue and names the column, and only that column is searched.
Pick All Columns to search everything again. Your pick stays while PropKaki is open, and goes back to All Columns if you hide that column with Customise.
Each column's ⌄ also has its own Search, inside its filter: it finds values in that column to tick (How do I filter a column?).
How do I sort the list?
Press a column's heading to sort by it, and press again to flip it; an arrow shows which way. Or press the heading's ⌄, or right-click the heading, and pick a sort. The words follow Excel:
| Column | Sorts |
|---|---|
| Words and choices | Sort A to Z · Sort Z to A |
| Numbers and amounts | Sort Smallest to Largest · Sort Largest to Smallest |
| Dates | Sort Oldest to Newest · Sort Newest to Oldest |
A column whose choices run from one end to the other also sorts by them. Its ⌄ has two more lines under Sort A to Z · Sort Z to A:
| Column | Extra sorts |
|---|---|
| Readiness | Hot First · Dormant First |
| Value | Very High First · Low First |
| Urgency | Urgent First · Low First |
| Stage | Exploring First · Completed First |
| Timeline | Urgent First · Flexible First |
| Offer Status | None First · OTP Issued First |
| HFE Letter | None First · Approved First |
| Agency Agreement | None First · Exclusive First |
| Preferred Floor | Low First · High First |
| Segment | CCR First · OCR First |
| Furnishing | Unfurnished First · Fully Furnished First |
On these columns, pressing the heading — or picking it under Sort above the list — gives the first of the two, such as Hot First; press again for the other. Hot First runs Due, Hot, Warm, Cold, Dormant, then Closed; Dormant First is the exact reverse. Point at the heading's arrow to see which order is on.
People with an empty cell come last both ways. The list opens in Value order with no arrow. Groups is the one column that doesn't sort.
If you change a cell while the list is sorted, that row stays where it is, so you don't lose your place. Press a sort again — the same one or another — and the list is sorted with everyone's latest values.
How do I filter a column?
- Press the column's ⌄, or right-click its heading.
- Under the sorts there is a Search box and a checklist: (Select All) first, each value your prospects hold, then (Blanks) for an empty cell.
- Untick what you don't want, or search and tick what you do.
- Press Ok. Cancel, or Escape, leaves the filter as it was.
The heading shows a funnel while it's filtered. Filters on several columns work together. On Groups, a person in several groups shows if any of their groups is ticked. A column with levels, like Readiness or Stage, lists its values in their own order, not A to Z.
The checklist covers your whole book, not only the first 500 people the list shows: on a bigger book the rest are read as the panel opens, and the checklist fills in when they arrive. A filter that's on reaches all of them too.
If you change a cell so that the person no longer matches the filter, their row stays until you press Ok on a filter again, then the filter reads everyone's latest values.
After an import, a column holding fields that need reformatting also has Show Errors in its panel, with its count — see Fix fields that need reformatting.
How do I clear a sort or a filter?
Open the column's ⌄ and press Clear Sort and Filter. It clears that column's filter and, if the list is sorted by that column, puts it back in its opening Value order.
It's lit when the column is filtered or the list is sorted by it, and greyed when neither — sorted by Locations, the line is greyed in Deal Type's panel. Other columns' filters stay as they are, so clear each one from its own panel.
How do I change one cell?
Double-click a cell, press Enter or F2, or just start typing. It saves as soon as you finish:
- Words, numbers and amounts that fit the column edit in the cell. Enter saves; Esc cancels.
- A value cut off at the column's width opens a one-line box under the cell, so you can see all of it. Its hint reads Enter Save · Esc Cancel.
- Long-text fields — Notes, Next Step, Plan B, Why Lost, Blocker, Reason Details, Condition, Viewing Times, Feng Shui, Business Use, Frontage and Footfall and Interests — open a wider box under the cell, 4 lines growing to 12. Its hint reads Enter Save · Shift+Enter New line · Esc Cancel, and your line breaks are kept. A click away saves it too.
- A list, like Readiness or Deal Type, opens its choices — ↑↓ and Enter pick. Typing a letter opens it too.
- Several values, like Locations: type one and press Enter to add it, then press Ok. A word you typed but didn't add is saved too; Cancel drops the change. To Find Out offers every field you could still ask about, with Search at the top.
- Follow-Up opens the calendar with Add Note under it. Pick a day, then Ok.
Pressing another cell while you're editing saves your edit in the cell you started in, then moves. Click a cell you can't edit here, such as Last Reply, and it gets a red outline with This can't be edited here. for 2.5 seconds. For many cells at once, see Edit many prospects at once.
What is the Urgency column?
Urgency sits right after Name, before Readiness, and is on by default. Its heading reads How soon they need your attention — Urgent, High, Normal or Low.
- Change it like Readiness: double-click and pick Urgent, High, Normal or Low. Set Value, Paste, Fill Down and Undo work on it too.
- It sorts and filters like Readiness and Value.
- A spreadsheet column headed Urgency fills it when a box says Urgent, High, Normal or Low. Anything else in that column comes in as a red box holding your file's words, to reformat on the sheet.
It isn't Readiness: a Cold client can still be Urgent. See What does Urgency mean?
Can I search and sort the Groups board?
Yes. In Prospects → Groups, Search and Sort sit on the top line, after the board you're looking at, and work on every group at once.
- Search finds people by name, phone number, email or What They Want as you type. Each group's count follows, and a group with no one matching shows 0. ✕ brings everyone back.
- Sort offers Manual · Last Reply · Follow-Up · Readiness · Name, with a tick by the one that's on. Last Reply puts the newest reply first, Follow-Up the soonest or most overdue first, Readiness runs Due, Hot, Warm, Cold, Dormant, then Closed, and Name goes A to Z. People with nothing to sort by come last. While any sort but Manual is on, the Sort pill is lit.
Manual is the order you arranged the cards in. Another sort only changes what you see — it never rearranges your order, and picking Manual brings it back exactly as you left it. While another sort is on, a card can't be dragged within its group: the pointer shows a no sign, and a grey line under the group's header says You’re sorting by Last Reply, so the order is set for you. Switch Sort to Manual to arrange it yourself. — naming the sort that's on. Dragging it into another group still moves the person there, into that group's own order. To arrange the cards yourself, see Group your prospects.
The board's Search and Sort are its own, apart from Individuals'. They last while PropKaki stays open, and a reload starts afresh.
What does the Groups column show?
Groups, right after Value, shows the groups each person is in as small blue pills — your own groups first, then those a rule fills, then their Readiness and Value groups. The first two show; +3 stands for the rest. Point at a cut-short pill or at +3 for the full names.
- Double-click their Groups cell, or press Enter on it. Your groups open under their headings, ticked where they're in.
- Tick a group to add them, untick to take them out.
- Press Ok. Cancel, Escape or a click away changes nothing.
A group a rule fills is greyed, with Set by their profile. New Group…, the list's last line, starts a group with this person in it. Groups filters like any column but doesn't sort.
