I find that Google Sheets can be an incredible tool for organizing projects — the endless rows and columns let me track and categorize things to my heart’s content. (You should see my byzantine spreadsheet for my family’s personal finances.)
Until recently, though, I’ve run into one major limitation that irked my organizational brain. If I wanted to add hyperlinks to a cell, I could only hyperlink an entire cell instead of hyperlinking individual words inside it. That meant, for example, if I wanted to track interesting links about personal finance in my spreadsheet, I’d have to make individual cells for each one of those hyperlinks, which could quickly fill up way more cells than I’d like.
But earlier this summer, while researching a b…