I know how to do it on Excel, but cant seem to get it to work on Smartsheet.
I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.
Lookup was my idea in Excel, but I cant find anything that would do this in Smartsheet.
as a very crude and basic example:
Overview information: 665 hours
row 1: 223 hours
row 2: 436 hours
row 3: 566 hours
row 4: 665 hours
Thank you in advance