Has anyone built a Field Service Management solution in Smartsheet?
I need to maintain a database of;
- store locations
- technicians, their backup tech and their backup of the backup tech
- dynamic schedule of availability of said technicians
I envision some form of a 'lookup' worksheet where appropriate and relevant data from database is pulled in based on some questions;
i.e., is service required during business hours or after hours, where geographically is service required; if first tech is not available, who is second tech to call, etc.
A third component of this solution is to allow for ease of data entry on the tech's manager's side. Tech Manager needs to populate database with availability of each of his techs.
I'm just starting to let this idea percolate in my brain and have some ideas, but wondering if anyone out there has built anything similar that may be able to offer advice, tips and tricks, direction, etc.