So I’m trying to make a template to help streamline some QA work going forward and I’m trying to make it so that we can just make copies of one folder with the functional specs and the QA plan and use that as a sort of automated process. I’m running into the issue that Excel links need to be absolute so it’ll break the moment the first copy of the folder is made.
Theoretically I think that if I put into a cell a spot where a person can put the one drive link to a document, then using names and other references to that, I might be able to emulate a relative reference, but has anyone ever actually tried something like this before? Am I better off writing code for this in some other language rather than forcing a proverbial square peg into a round hole?
Mya Lupinetti is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.