scheduling a start/end date calendar for a list of tools
I'm looking for a way to track and schedule a list of tools. So right now, we have a list of specialty tools used for certain projects on Smartsheet. Whenever a tool is needed, it is shipped to the location where it's needed, and then it's location is updated in Smartsheet.
What I'd like is a way expand on this. And so it's easy for anyone at our company to use, I'd like to create a form where someone can choose a tool (or better yet, multiple tools) from the list, and then enter the start date, end date, and location for that tool. It would really be nice if something like the Gantt chart, with a calendar adjacent to the row where the tool is listed, could show the schedule of when a tool is reserved for use and where.
The Gantt feature only seems to allow one set of start/end dates (so a project timeline can be created). Since multiple start and end dates for each line item in the list will be needed, I'm assuming each item listed will need it's own spreadsheet where schedule and location can be tracked, where every time the schedule form is filled out, the next row in that tool's spreadsheet will populate with the entries.
This seems easy enough, but I'm just wondering the best way to display this schedule. I'd like to be able to filter multiple tools' schedules, and see them all adjacent to one another to be able to compare, see trends, and determine if a certain tool's schedule is filling up, signalling that maybe we need to get another one. Something similar to the Gantt chart, where the schedule is adjacent to the row, and will also filter when the column of tools is filtered, would really be perfect.
Is there a way to make this work? If not, are there suggestions for other ways to display this that would give the same information and usability?