Cross Sheet Fixed Cell References

Dean Arvan

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.

Werner Gerstacker

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.

Dean Arvan

That is a good thought but I do not think it fully addresses my specific situation

Werner Gerstacker

Maybe you need to elaborate a little on your specific situation so that somebody can come up with another idea.