Can you link to a cell and lock the link to the cell instead of the data?
For example, you are using a form and you want to display the data on dashboard that is the most relevant, i.e in the top row of a sheet? i know you can do this with reports, but i am looking at using the data metrics on a dashboard to update due to a column updating when a new form is submitted. Please let me know if anyone knows if this is possible.
Help Article Resources
Check out the Formula Handbook template!