Easily convert data to dropdown chips in Google Sheets

What’s changing

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. 

Getting started 

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.

Rollout pace 

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

Availability 

Available to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts 

Resources 

A simplified experience for Workspace users to add 2-Step Verification (2SV) methods

What’s changing

We’re simplifying how users turn on 2-Step Verification (2SV), which will streamline the process, and make it easier for admins to enforce 2SV policies in their organizations.  

Here are some of the important changes with this change:

Users may add “second step methods” (such as Google Authenticator, or a hardware security key) before turning on 2SV. This is particularly helpful for organizations using Google Authenticator (or other equivalent time-based one-time password (TOTP) apps). Previously, users had to enable 2SV with a phone number before being able to add Authenticator.
Users with hardware security keys will have two options to add them to their account on the “Passkeys and security keys” page:‘Use security key”: this registers a FIDO1 credential on the security key even if the key itself is FIDO2 capable.‘Create passkey and follow instructions to “use another device”: this registers a FIDO2 credential on the security key, and will require users to use the key’s PIN for local verification (this creates a passkey on the security key).Note: users will continue to be asked for their password along with their passkey if the admin policy for “Allow users to skip passwords at sign-in by using passkeys” remains turned OFF (this is the default configuration).
If an enrolled 2SV user turns 2SV OFF from their account settings, their enrolled second steps (such as backup codes, Google Authenticator, or second factor phone) are not automatically removed from their account. Before this change all second factors would be removed when the user turned 2SV off. Note: When an administrator turns off 2SV for a user from the Admin console or via the Admin SDK, the second factors will be removed as before, to ensure user off-boarding workflows remain unaffected

Getting started

Admins: Visit the Help Center to learn more about how to protect your business with 2-step verification.End users: Visit the Help Center to learn more about turning on 2-step verification.

Rollout pace

Rapid Release and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on May 6, 2024

Availability

Available to all Google Workspace customers and users with personal Google accounts 

Resources

Block compromised mobile devices using context-aware access

What’s changing 

Using context-aware access, you now have the option to automatically block access to Google Workspace data from compromised Android and iOS devices. A device may be counted as compromised if certain unusual events are detected, including devices that are jailbroken, bypassing of security controls, modification of restricted settings, and more.
Creating a new rule to block compromised mobile devices
Blocking message for compromised iOS and Android devices

Getting started

Admins: Visit the Help Center to learn more about how to create context conditions and apply rules with compromised device signals, and our Developer documentation regarding custom access level specification. Compromised device events reports can be viewed in the security center by going to Security > Security center > dashboard > compromised device events.

Rollout pace

Block access to Google Workspace data: available immediately for both Android and iOS.Remediation message: available immediately for Android, available on May 9, 2024 for iOS. 

Availability

Available to Google Workspace
Enterprise Standard and PlusEducation Standard and PlusFrontline StandardEnterprise Essentials PlusCloud Identity Premium

Google Workspace Updates Weekly Recap – May 3, 2024

New updates

There are no new updates to share this week. Please see below for a recap of published announcements. 

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Updated keyboard shortcuts and first-letters navigation now available on Google Drive web 
First-letters navigation enables users to quickly and easily navigate a list of items in Drive via keypress. Users can move focus within a file list in Drive by pressing the first letter(s) of the file’s name. Pressing the same letter again will navigate to the next item starting with that letter. | Learn more about first-letter navigation.
Configure managed iOS apps for your users’ using Google Mobile Device Management 
Directly from the Admin console, admins can remotely set custom configs for managed iOS apps on end-user devices for their enterprise using Google Mobile Device Management. Managed configurations are applied using XML property lists and the same app can be configured differently across different domains, groups, or organizational units (OUs). | Learn more about configuring managed iOS apps for users. 
Available in open beta: Build AppSheet automations using Google Forms 
We’re introducing an integration between AppSheet and Google Forms. With this update, Google Forms submissions can act as event triggers within AppSheet Automations. These automations can then take many different actions, such as sending notifications or approval requests to Gmail or Google Chat, or even calling a custom Apps Script function. | Learn more about AppSheet automations using Google Forms.
Google Meet increases support for ultra-low latency live streaming to the first 25,000 viewers 
For Google Workspace editions that support 100,000 viewers, we’re increasing the availability of the Google Meet ultra-low latency viewing experience for live streamed meetings from the first 10,000 viewers to the first 25,000 viewers. All additional viewers will have the standard live streaming experience. This update is available for live streams within your organization on web and mobile. | Learn more about increased support for ultra-low latency live streaming. 
Introducing AppSheet Organizations 
We’re making it easier to manage your AppSheet users with the introduction of AppSheet Organizations. An AppSheet organization creates organization administrators with a centralized tool to manage all of the teams in the organization and delegate team management responsibilities to team administrators.| Learn more about AppSheet Organizations.
Hide tiles without video during Google Meet calls 
We’ve added the option to hide non-video tiles, so that users can avoid clutter on their screen if they are interested to only see the participants with their videos on. This option can help reduce screen clutter and focus on video-enabled participants, meanwhile users with their videos off can be shown on screen if they speak. | Learn more about hiding video tiles.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains: 
Scheduled Release Domains: 
Rapid and Scheduled Release Domains: 

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).   

Hide tiles without video during Google Meet calls

What’s changing 

We’ve added the option to layouts, so that users can change their layouts to avoid cluttering the screen if they are interested to only see the participants with their videos on. This option can help reduce screen clutter and focus on video-enabled participants, meanwhile users with their videos off can be shown on screen if they speak . Note that this feature, same as other layouts options, is only specific to your meeting view and does not impact what other participants see or set for their layouts during the meeting.
To hide non-video tiles, go to Settings > Change layout > Hide tiles without video.


Getting started

Admins: There is no admin control for this feature.End users: Visit the Help Center to learn more about adjusting the tile view in Google Meet.

Rollout pace

Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 2, 2024Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 16, 2024

Availability

Available to all Google Workspace customers and users with personal Google accounts 

Resources