I am creating a drawing template that has a different sheet format for additional pages than it does for the first page. Both the template and the two formats are saved to a cloud server like Box so that they can be accessed by all of our users. I have two problems when trying to set this up. Both have to do with the file path being different for each user who accesses the templates. 

The first is that when I specify the template location under system options, I specify a file path C:\Users\username\...\Drawing_Templates the file path only works for the account that the work is being done on as each account will have a different username. If I use the Copy Settings Wizard to try and copy all of my template locations to other accounts, it is unable to access the locations. Instead of being able to use the Copy Settings Wizard to import all of the template locations, I have to add them to each user account manually. Annoying but doable.

The second and seemingly much more difficult is when the drawing template references the sheet format document for the second sheet under Tools>Options>Document Properties>Drawing Sheets. I specify the file path for the sheet format document, but again it is specific to the user account (C:\Users\username\...\Drawing_Templates\second_sheet.slddrt), so even if all user accounts have the drawing template file locations correct, when they create a drawing from the template and try to add a second sheet, the file path for that sheet's format can not be located because the username is different. The only workaround I can think of is to create a local copy each drawing format and drawing template for each user account, which kind of defeats the whole purpose of having the templates on a central server.

I tried using a variable %username% in the file path, but I could not figure out how to get it to work. I feel like this has been solved by someone already, so hopefully they can provide some insight. Thanks!