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
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
-
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..
-
Hello Dave,
You might try using the $ to lock the row number in your cell references, example:
=[status narrative]$1
Details on formulas can be found in our Help Center: http://help.smartsheet.com/articles/775363-using-formulas
