Can you link to a cell and lock the link to the cell instead of the data?

Brendan Ginns

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.

Thanks

Genevieve P.

Hi @Brendan Ginns

If you're on a Business or Enterprise account, you can set up a Metric Widget to look at a Sheet Summary Field instead of the grid of the sheet.

Then you can use a formula in the Sheet Summary Field to make sure the relevant data is being surfaced.

For example, if you have a Created Date System Column in your sheet, you can use this to find the MAX date (most recent submission) and pull back data in another column from that row.

=INDEX([Column to Return]:[Column to Return], MATCH(MAX(Created:Created), Created:Created, 0))

Let me know if this makes sense and will work for you!

Cheers,

Genevieve