Need to Return Latest Update in Repeating List of Assets


We have a set of Hardware Assets that we use as a "Check Out/Check In" system in Smartsheet. Our employees can check out a piece of hardware and check it in when they are done using it. We use a form to intake the request and update the asset as out, or returned when the asset makes it back in.

In this example, I have 5 total assets and I am looking for a way to return the latest update/status for each of the 5 Assets. For each Asset I want to know; Who Has it (Checked out by), the date it should be back (Date In), and Status.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!