Link to most recently added row

Dave Ungar

I'm looking for a way to display (in Sights, but if you're not a user of Sights, just think of it as linking from one sheet to another) whatever the last row was that was added to a sheet.

 

The way I'm conceiving of this is when a row is added, the top row in the sheet contains formulas that grab that information.  If I were jjust grabbing the 'Created Date' I could use Max(). .. so I can sort of identify what the last row is and flag it, but I can't figure out how to take all of the contents of that row and refer to it as essentially "Current status" .  

Dave Ungar

Or, alternately if I add new rows to the top, how could I create a formula (e.g. =[status narrative]1 where the "1" remains constant as a 1, even if I add a row above it.  That is, always read the first row .. and if I add a new row above the first row, read the new row & not the former first row.  ..I'd be happy with a way to do this with a formula or with cell linking, whichever works..