From Philip Boos
Use the following formula to connect your Google Sheet to the Blue Drive.
=ArrayFormula(if(isblank(Scheduler!A2:A),,"\\blue.umhsnas.med.umich.edu\umms-digitalsign\BLUEDRIVEFOLDERNAME\"&Scheduler!A2:A))