What’s changing

In March, we introduced nan expertise to insert preset dropdown chips that are configured for communal usage cases for illustration privilege aliases reappraisal statuses successful Google Sheets. Today, we’re adding a caller characteristic that helps you quickly person ranges of information into dropdown chips successful bulk. 

If you person a file of information that includes a assortment of information values (e.g., different task statuses for illustration connected track, paused, completed), Sheets will show a “Convert to dropdown chips” proposal erstwhile you click into your information range. By hovering complete that indicator, you tin preview nan proposal and past person to dropdown chips successful 1 click. 


Getting started 

  • Admins: There is nary admin power for this feature. 
  • End users: 
    • To insert dropdown chips connected your own, type “@” followed by “dropdown. 
    • To move disconnected this feature, go to Tools > Suggestion controls > (deselect) Enable dropdown spot suggestions. 
    • Visit nan Help Center to study much astir inserting smart chips successful your Google Sheets.

Rollout pace 

  • Rapid Release domains: Extended rollout (potentially longer than 15 days for characteristic visibility) starting connected May 7, 2024, pinch expected completion by May 30, 2024
  • Scheduled Release domains: Gradual rollout (up to 15 days for characteristic visibility) starting connected May 30, 2024 

Availability 

  • Available to each Google Workspace customers, Google Workspace Individual subscribers, and users pinch individual Google accounts 

Resources 

  • Google Help: Insert smart chips successful your Google Sheets 
  • Google Workspace Updates Blog: Use caller array templates and dropdown chips successful Google Docs to create highly collaborative documents 
  • Google Workspace Updates Blog: Set up dropdown chips much easy successful Google Sheets