The Salesforce task subject field currently accepts free-text input, which creates inconsistent data that undermines reporting accuracy. Converting this field to a controlled dropdown list ensures uniform task categorization and enables reliable metric tracking across the sales and project management workflow.
When users can type anything into the task subject field, small variations accumulate quickly:
These variations make it impossible to accurately aggregate tasks by type in reports. For example, tracking how many change order estimates are being processed in a given period requires that all such tasks share an identical subject string.
"How many change orders we're estimating or whatever... if people are typing in, then they're going to have different... they misspell something, or they add an extra space. When it comes to reporting, it's going to be hard to categorize it."
— Karly Oykhman, working session with Quarra Stone
The task subject field in Salesforce behaves as a hybrid field: users can type freely, but a dropdown suggestion list also appears when clicking into the field. This hybrid approach does not enforce consistency — users can still bypass the dropdown and enter arbitrary text.
Convert the task subject field to a strict dropdown (picklist) so that only predefined values can be selected. This eliminates free-text entry for the subject while preserving flexibility in other task fields (description, notes, due date, assignee).
Compile the approved task subject list — the account owner (lldurham at Quarra Stone) is responsible for finalizing the list of valid task types. Known candidates include:
- Price Change Order
- Do Research
- Make Contact
- Schedule Call / Meeting
- Send Proposal
- Follow Up
(List should be finalized by the client before implementation)
Update the field definition in Salesforce Setup — change the Activity/Task Subject field from a text/hybrid field to a picklist with the approved values.
Validate existing task data — review open and historical tasks to assess whether existing free-text subjects need to be remapped to the new picklist values.
Communicate the change to users — notify all Salesforce users of the new behavior before deployment to avoid confusion.
Once implemented, the dropdown enables accurate reporting on:
This supports the broader goal of using Salesforce as a single source of truth for sales and project activity metrics.
This change was discussed in the context of Quarra Stone's lead-to-opportunity workflow build-out. Project Managers are currently using the Opportunity object to assign tasks to estimating (as an interim measure while the Project object is developed), making consistent task subjects especially important for cross-team reporting.