Help with using a check-in/check-out system with Chromebooks for students
We are using Smartsheets to track repairs to student's Chromebooks in our building. The Chromebooks are tested (by students) using a Google form to log answers which then puts them into a Smartsheet to be queued for repair. Once the Chromebook has been repaired, we change the status, and it moves to the "Ready to Hand Out" sheet. I have another sheet where I can upload what Chromebooks are checked out to a Student. With automation and formulas, I have all of this running smoothly, but the issue is when a Chromebook that has already been repaired comes back for another repair. Because it's already been "Checked-out", It will not show back up in the ready-to-hand-out sheet. Apologies if this is confusing, you can see where the 71885104 asset tag was repaired again on 1/11/24 but is not showing back on the ready sheet, but on the checked-out sheet.
Help Article Resources
Check out the Formula Handbook template!