The following columns were added to the first sheet of annotation-metadata in order to automatically generate href formatting in "cite as" column, with an example entry:
Columns are:
E = edition-URL AC = href-link AD = original-CHANGE-HERE-to-automatically-update-cite-as AE = remove-link AF = cite-as
Formulas used are as follows (using row 2 as example):
AC = href-link ="<a href="&char(34)&E2&char(34)&">"&E2&"</a>"
AD = original-CHANGE-HERE-to-automatically-update-cite-as This was copied from what was in the "cite-as" column originally. @ps2270 - PLEASE NOTE THAT IF THERE ARE ANY CHANGES TO BE MADE TO A CITATION, THEY SHOULD BE MADE IN THIS COLUMN. fROM THIS COLUMN, THE "CITE-AS" COLUMN PULLS ALL INFO EXCEPT THE LINK
AE = remove-link =LEFT(AD2,LEN(AD2)-64) each essay URL is 64 characters long including the space preceding it, hence removing the last 64 characters.
AF = cite-as =AE2&AC2