Can a Smartsheet Form Show information from a sheet?

edited 04/12/24 in Smartsheet Basics

Hello! I am very new to smartsheet and am trying to learn. My first project on smartsheet for my team is to develop a form that employees will use to check out and then back in an item while at work.

I've got the Check Out part done and have it feed to a sheet so that supervisors can monitor who has what. However, I don't know how I would do the check back in process with a form.

My idea is to have a drop-down menu asking the employee if they are checking out an item or checking it back in. If selecting checking in, they would see a list of items checked out by employees (presumably populated from the sheet) and they would mark that item as checked back in. Is this possible? and if so how would I go about doing this?

Thank you all!