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
Check out the Formula Handbook template!