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.
Thanks
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!