Archived 2016 Posts

Archived 2016 Posts

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

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

Trending Posts