We are trying to link our spreadsheet data from one workbook to another within Box, using the Google Sheets capability. Unfortunately, Box does not currently support the IMPORTRANGE function to make the data easily shared between 2 workbooks. I've tried about 100 different formulas this afternoon but nothing is working.
Is there another solution people have found to link between 2 workbooks within Box seamlessly? Do I need to include a full path in the formula to make it work?