Display most recent data entered in a cell


I am currently developing a sheet that has a 'notes' column I will be entering using to track notes for a given row. In the 'notes' column, I would like to be able to just display the most recent entry within a given cell. In other words, if I were to enter 'test12345' in the cell on a specified date and 1 hour later I add enter 'test678910' in that same cell, I would like it to only display the most recent cell entry (in this case 'test678910'). Is there a straightforward way to accomplish this? I initially tried to accomplish this by creating a system column for 'created' date and then added a 'helper' column that had the formula =INDEX(Notes@row, MATCH(MAX(Created@row), Created@row)), but this did not work. Any help would be appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!