At this time, cross-sheet formulas only function within Smartsheet. There also isn't a way to bypass the 5,000 row limit. When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have these functionalities in Smartsheet.