reference another sheet - not from a cell, but pull from sheet summary formula
I need to pull a sheet summary formula into another sheet.
I've tried right clicking in the desired cell, link to cell in another sheet, but can only link to actual cells in the other sheet. I can't navigate over to the formulas in the sheet summary section right hand side to pull that in.
Another option I tried was =sum( reference another sheet, but it still wants to just pull information from the sheet itself, and not the formula.
I've got a complicated formula in my summary formula and am able to get the result onto a widget but I can't figure out how to get it onto another sheet to do more with it.