Our prayers go out to the people of Japan and hope that things will improve soon for them.
I had a request last week to create a new spreadsheet to display the 90 Day Inspections(or user defined number of days) Due or Past Due along with the Location so that they could sort the list by Location
When I created it I also added the Deptartment or Area and the Customer fields in addition to the Location field.
This spreadsheet will link to and display the following columns fromyour TATEMS data:
Location
Dept or Area
Customer
Equip Num
Date Insp Completed
Next Inspection Due
Equip Desc
Equip Sort Order
Here is a short video to that shows you the Spreadsheet in action.
You can get the spreadsheet here
Have a great week!
Thanks Again
Marc Ready