Google Sheets CSV image (icon) hyperlink formula formatting issue

[joonaspaakko]

So apparently something has changed somewhere (probably during the big overhaul from 0.2.8 to 0.2.9) and there's an extra ' character before all cells with a hyperlink+image. Regular hyperlinks seem to work just fine.

So instead of seeing the clickable icons, like on row 23, you see the raw formula, because it's formatted like a string, rather than a formula.

1. cover image
2. play sample button
3. play book using cloud player
4. search for book in GoodReads

[BTMeeks]

I used the Google Sheets search-and-replace function to fix this. I selected the columns with the issue (B-D, I believe), and replaced '=HYP with =HYP with the "also search within formulas" option.