I’m curious to know if there has been a recent change to how Sheets applies formatting to People Chips?
I have a helper function that inserts smart chips but recently the chip just displays with the users email instead of the name. The reason I’m focusing on the formatting is because when I go to Format → Smart chips I can see that Default is checked. Once I uncheck it, the chip displays correctly. I’ve tried using different values for displayFormat and omitting it all together and nothing works. Unfortunately there’s also no way to currently change the formatting of the chip independently.
Any ideas would be appreciated, otherwise I’m going to have attempt something different for this particular situation.
Thanks!
4 Likes
Hi @Luis_Benitez This behavior is likely due to a recent Sheets UI change rather than an Apps Script regression, as People Chips now appear to default to email display under certain “Default” smart chip formatting states; since there is currently no API to control chip display format directly, the only reliable workaround is adjusting the Smart Chips formatting manually or using an alternative insertion method until Google exposes display control via API.
Thank you for the response Aleksei! Out of curiousity, are these changes posted somewhere? I would really like to stay up to date.
When I try to update them manually, they immediately revert back to email format. I can no longer make it display names except for those who have Google accounts that can access the file.
For my purposes this makes the people smart-chip almost useless.
When I try the smart-chip from the table, I get a warning “This value does not match the column type people chip”
I really need names and not email addresses. I am willing to sacrifice the chip and go to two columns (one name and one for email) but it is sad that the smart-chip doesn’t work.