Thanks for the reply!
Workaround I used for anyone who encounters this:
- Set the column type to “Multiple lines of text” (the link I was trying to insert was longer than 255 characters, otherwise the type “Single line of text” works as well)
- Make a custom format (Column settings > Format this column). I inserted a json that makes the string blue and clickable so it redirects you to the location of the link.