I'm building a complex Google Sheets document and for one sheet I use the function IMPORTRANGE. It's very handy and imports new rows from another sheet when they are added. The problem is this:
After the last row of the import from my IMPORTRANGE I add a small 'Total' calculation to SUM all of the above numbers.
What I want is that the 'total' calculation row moves down when the IMPORTRANGE expands with more rows.
Is there any way to achieve this dynamically / automatically so that my 'Total' calculation moves down and keeps summing?