Hello,
I have looked through some posts about this topic, but i can't seem to get anything to work. I have an O.O.S. list which lists a set of trucks and trailers that have been put out of service. I probably should start by stating that this is a google sheets document. I am not for sure how much that makes a difference. The process starts by a mechanic filling out a form, the raw data then populates under the O.O.S. Form tab. I created a new tab to help make the data aesthetically pleasing called O.O.S. Record and it is under the Current O.O.S. heading. The mechanic can put the unit back into service using a different form, which will take the unit off of the current out of service record.
I would like to essentially create a dashboard / another tab that actively lists the units currently out of service. Basically I would like the current out of service list to not have blanks. Actually, if that could be done on o.o.s. record tab and also on a separate tab that would be great. FYI units will be subtracted and added to the lists. Any help would be greatly appreciated.
Thank you
Bookmarks