Dashboard -- Can you pull data from a specific cell # even if the data in it is changed daily?
I have a sheet/grid attached to a form. Every day we add a row utilizing the form, but I have it organized to change to be added to the top row. In the dashboard when I arrange the data to be pulled from the specific cell, which I want to be in row 1.
Unfortunately when we utilize the form it adds a row and alters the equation. How can I make it always pull the data from row 1?
After submitted a form it changes to =$ColumnName$2 which we don't want.
Help Article Resources
Check out the Formula Handbook template!