Make a spreadsheet tracker for unanswered property questions

Use consistent statuses and filters to organise follow-up without hiding unresolved items.

Start with questions rather than scores

Open an empty spreadsheet and create columns for question ID, topic, exact question, responsible contact, date asked, status, source reference and next action. Enter one question per row. In a fictional comparison between an existing home and a proposed build, suitable entries might ask which room measurements need confirmation or whether a written offer includes a particular task. Avoid inserting identity details or confidential documents into a sheet that will be widely shared. The tracker organises follow-up; it cannot decide whether the property is legitimate, structurally suitable or a sensible financial commitment.

Use a small status vocabulary

Choose statuses that describe evidence rather than optimism. For example, not asked, asked, reply received and clarification needed are easier to interpret than good, risky and perfect. In LibreOffice Calc, select the status cells and use Data, Validity to define an agreed list. Add a short input note explaining that reply received does not mean the answer has been independently verified. The official help explains that validity rules work when new values are entered and may not apply to existing or pasted content. Check copied rows manually and use the application's invalid-data tools where appropriate.

Filter without mistaking hidden rows for progress

Apply a filter to the table header so you can show questions for one contact or one topic. Practise first on a copy containing fictional entries. Filter for clarification needed, then reset the filter and confirm the full list returns. LibreOffice's filter guide describes how filtering restricts displayed records; a hidden row still exists in the data. Before a household meeting, show the active filters clearly or provide an unfiltered export. Otherwise, a person reading a short filtered list may wrongly believe the missing questions are finished or that another participant deleted them.

Review the tracker as a team

Read each open item aloud and ask whether the next action is precise enough to perform. Replace contact council with a concrete request to the relevant office, including the property reference that an authorised adviser says is appropriate. Keep professional conclusions in their own referenced documents rather than paraphrasing them into a coloured status cell. Save a dated copy after the meeting and note which questions changed. End by assigning responsibility for obtaining the missing evidence, without inventing deadlines for outside organisations. A useful tracker reduces forgotten follow-up while keeping the limits of the available information visible to everyone.

For a quick usability test, give another person the practice tracker and ask them to find one unanswered question and its next action. Then show all rows again. If either task is difficult, simplify the headings and remove unnecessary fields before recording real enquiries.

Sources & further reading

Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.

  1. LibreOffice: Validity of cell contents
  2. LibreOffice: Applying filters

This guide is general information. Source notes are not a claim of independent professional review.