Hello Community,
On a dashboard when you add a metric widget and link to a sheet it gives you the option to choose cell data or summary data. In a sheet if you link to another sheet there is no option to link to a summary field, on cells. Does anyone know if it is possible to link to summary field from a sheet?
The background is I have a sheet that keeps a running history (rows are added weekly to top) via a form. If you link to cells and I grab the top row of cells when new rows are added the link stays with the original top row and moves down and does now stay linked to top row. I saw someone do a summary field that used INDEX with 1 to essentially grab the top row and that works great but I need to link that to another sheet but the sheet won't let you link to the summary field like the dash widget. I know I could probably get more complicated and have yet another sheet and move the other rows to a separate sheet and only maintain the one sheet but I was trying to keep this simple. Any suggestions?
