Have you ever assigned a Google Forms Quiz but forgot to include a field for students to type their names? In the tweet below from Jamie Agombar, you can see how easy it is to use "Smart Chips" in Google Sheets to convert email addresses to student names.
- Open the Google Forms Response page
- Click the green Google Sheets icon to view responses in an organized spreadsheet
- Select the column that includes Email Addresses
- Right click and select "Convert to People Chip"
- Watch the magic happen as the email addresses are converted into names!
Using Google Forms for quizzes/tests? Didn't include a Q for first & last name? 😩
— Jamie Agombar (@AgombarTechDDSB) March 31, 2022
💡 Smart Chips can easily convert email addresses to people in your organization!
Google Sheets > highlight email addresses > right-click > convert to people chip... and DONE! 🤩#edtech #Google pic.twitter.com/w61rFuAMTd
