Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Link to most recently added row

Dave Ungar
edited 12/09/19 in Archived 2016 Posts

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" .  

Comments

This discussion has been closed.