How to select a last added value from a column

Jasmine Hassan
Jasmine Hassan ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made.  What I want is a formula that updates automatically as I populate new rows.  

Below is a screenshot that shows the columns I am working with.  The value of the column “Closing Stock” I am trying to populate in a new row as “Opening Stock”.  The goal is to capture the most recent entry of “Closing Stock” column based on the “Product Name” column.

Any suggestions?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!