I am copying the URL address of certain items and placing them in a spreadsheet, I would like these to load the actual item. Sometime this work sometimes not, I suspect it depends on whether I create the link before or after it is published/archived.

My workflow is that I am creating a crosscharge cost to send to another company made up of select cost items that are in other expense sheets. This seems the most efficient way to do this.