Book Library with Form

We have several books in our store that we lend out for employees to read and I need a way to easily keep track of requests and know if they are in use or available. Below are screenshots of what I am thinking but I am unable to figure out what type of formula I will need to know when a submission is made to request a book, if it is available or in use.

Has anyone ever done something like this before?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!