Multi select not working with data uploads
Does every option have an ID I gotta set instead, or is it just not working?
Using Cloud version.
3 Replies
Of course I made sure the values match 🙂
Hello @pjraven could you please describe your issue and repro ?
Description
The CSV import process does not work when mapping columns to multi-select or dropdown fields if the source file contains the options' text labels (e.g., "In Progress") instead of their internal system IDs (if those exist). The error message is generic and does not guide the user on how to resolve the issue, causing confusion.
Expected Result: The system should successfully import the data by matching the text labels to the existing options, or provide a clear error message stating that Option IDs are required for this field type.
Actual Result: The import cannot proceed for all mapped multiselect fields.
Steps to Reproduce
Create a "Dropdown" or "Multi-select" custom field (e.g., "Project Status").
Add options to this field (e.g., "Planning", "Active", "On Hold").
Prepare a CSV file with a Project Status column.
Populate the Project Status column using the text labels from Step 2
Navigate to the CSV import tool and upload the file.
Map the Project Status column from the CSV to the corresponding custom field in the system.
See error message
User Impact
This creates a significant usability problem. Users naturally assume the visible text label is the correct value to use for an import. The current workflow requires them to perform a separate data export just to find the internal IDs, making the process unintuitive and frustrating.
Suggested Enhancement
As suggested by the user, implementing a feature to map text values or create new options on-the-fly during the import process (similar to Monday.com) would resolve this issue and greatly improve the user experience.