Cross Sheet Fixed Cell References
Hello,
Is it possible to create a fixed cross sheet reference such that my formulas will always pull the first row of data from the target sheet? I am building a Dashboard off of results from a Form that I have set to add new submissions at the top i.e. row 1. As new submissions get added, I want the Dashboard to update, but the cross sheet references are not fixed to the first row of data.
Thank you,
--Dean.
Answers
-
Here's an idea, @Dean Arvan:
Add a system column as the very left column of your target sheet that automatically adds either a Row ID or the Create Date when a new form entry, i.e. row is created at the top.
Then use the COLLECT function to find the maximum value in this column (i.e. the latest date/time or highest Row ID) and run e.g. a vlookup from that value to the other columns you need in an interim sheet for your report.
-
That is a good thought but I do not think it fully addresses my specific situation
-
Maybe you need to elaborate a little on your specific situation so that somebody can come up with another idea.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!