I have a strange problem with my calculated column.
I want to build a link utilizing the ID of the entry. So I have a formula like this:
="<a href='someurl.html?id="&[ID]&"'>some text</a>"
To have this interpreted as HTML, I changed the type to "Date and time", which is some kind of a hack, but works.
The problem is that on some time, which I wasn't able to reproduce exactly, the formula breaks. From this time the brackets [ and ] are gone, and the link will only contain "ID" instead of the current items ID.
Any ideas? Thanks!
EDIT: I tested a little more. It seems that all existing links continue to work, but all links on new entries won't.