Which enquiries are actually ready for someone to prepare a quote? Build your lead sheet around that question rather than a broad sales status. The workflow below combines a readiness dropdown with a shared filter. Google Sheets saves filter settings, but ordinary filters are visible to everyone with access and editable by spreadsheet editors. Treat this as a shared queue, not a private saved view. [2]
Define what qualifies a lead for quoting
As a suggested layout, use columns for Lead, Service requested, Scope notes, Quote owner, Quote readiness, and Handoff note. Keep each enquiry on its own row. The readiness field should answer whether pricing work can begin; the handoff note should explain anything the person preparing the quote needs to know. Avoid using the same field for both readiness and the eventual sales outcome.
Suggested readiness labels are Needs details, Ready to quote, Quote prepared, and Not proceeding. Define Ready to quote in plain language for your business: for example, the requested work and relevant access constraints are understood. Agree on that definition before building the dropdown, so colleagues do not interpret “ready” as merely “the customer sounds interested.”
Create a controlled readiness dropdown
On a computer, open the spreadsheet and select the data cells in Quote readiness, excluding the heading. Click Data, then Data validation, then Add rule. In the Data validation rules panel, choose Dropdown under Criteria. Enter your readiness labels, using Add another item for each additional option, and click Done. [1]
Keep this field single-select: the suggested queue needs one current readiness decision per lead. Sheets rejects entries that do not match the dropdown options unless you choose Show a warning under Advanced options and “If the data is invalid.” For this workflow, retain rejection rather than allowing alternative wording. Put explanations in Handoff note instead of introducing near-duplicate statuses. [1]
Filter the shared sheet to ready-to-quote leads
Select the lead-tracking range, including its headings and all related columns. Click Data, then Create a filter. Open the filter control at the top of Quote readiness. Under Filter by values, uncheck the values you want hidden, leaving Ready to quote selected, and click OK. The resulting queue hides enquiries that are not ready for pricing work. [2]
Google Sheets retains filter settings even if the filtered data is removed. That supports a recurring shared queue, but it is not a personal view: other people can see the filter, and editors can change it. Suggested practice is to announce when the sheet is being used for quote preparation. To return to the full list and reset filtering, click Data, then Remove filter. [2]
Use a deliberate handoff rather than just changing a label
Hypothetical example: a cleaning business receives an enquiry for an office clean, but the requested areas are unclear. The coordinator marks it Needs details. Once the scope is clarified, they add the agreed areas to Scope notes, assign a quote owner, record the access requirements, and change readiness to Ready to quote. After drafting the quote, the owner changes it to Quote prepared.
As a working rule, ask the quote owner to review the handoff note before starting. If essential information is still missing, return the lead to Needs details and describe the gap. This keeps the readiness decision separate from responsibility: an assigned owner does not automatically mean an enquiry is ready to price.
Check the queue and avoid common mistakes
Common mistakes include marking incomplete enquiries ready, adding explanatory sentences as dropdown labels, and assuming hidden leads have been deleted. Filters hide data rather than remove it. Another trap is assuming a shared filter belongs only to you; coordinate changes with colleagues rather than silently changing their working list. [2]
Use this brief checklist before each quote-preparation session: confirm the intended range is covered; check that Ready to quote is the selected value; review each visible lead’s scope, owner, and handoff note; resolve missing details before pricing; and update readiness when preparation is complete. Periodically review the full list so unfinished enquiries still receive attention.
Sources
- Create an in-cell dropdown list – Computer – Google Docs Editors Help
- Sort & filter your data – Computer – Google Docs Editors Help
Prepared with AI assistance from the linked documentation, checked on 2026-09-25. Examples are suggested workflows, not claims of hands-on product testing.