Forum Discussion
Fixing #SPILL on Dashboard by auto-added new row when I add row to Table
I have a dashboard that I populate with data from chunks of data I've named in the Name Manager. (Note the data is also in tables.) Everything is set up and working on the dashboard, but the problem ...
Rather than using distinct formulas for the various parts of your dashboard stack them so they form a single spilt range. The following is more complicated than it need be because I have also inserted a blank row between the tables by EXPANDing the top one and have added a blank column to the second so that it matches the first in terms of columns.
= LET(
top, EXPAND(Table1, ROWS(Table1)+1,, ""),
bottom, EXPAND(Table2, , COLUMNS(Table2)+1, ""),
VSTACK(top, bottom)
)