Easily convert data to dropdown chips in Google Sheets
Tuesday, May 7, 2024
In March, we introduced the ability to insert preset dropdown chips that are configured for common use cases like priority or review statuses in Google Sheets. Today, we’re adding a new feature that helps you quickly convert ranges of data into dropdown chips in bulk.
If you have a column of data that includes a variety of data values (e.g., different project statuses like on track, paused, completed), Sheets will show a “Convert to dropdown chips” suggestion when you click into your data range. By hovering over that indicator, you can preview the suggestion and then convert to dropdown chips in one click.
- Admins: There is no admin control for this feature.
- End users:
- To insert dropdown chips on your own, type “@” followed by “dropdown”.
To turn off this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown chip suggestions. - Visit the Help Center to learn more about inserting smart chips in your Google Sheets.
- Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on May 7, 2024, with expected completion by June 24, 2024
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on June 24, 2024
- Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts