Hello,
I'm in need of a formula to automatically display the current inventory status of kits. It will need to show if it is in use, or if it has already been returned to my facility, plus just a few other items such as the clients name, expected return date, etc.
The problem I'm having is that it will need to ignore responses (blank cell as a response) if the kit has already been received, or isn't in use, which will continue through a year. We may have 1000 rows (patients) through a year? Basically it will tell me if it's ready to be given to another patient, or if it's in my hands.
Here is where the data is pulling from (one worksheet, multi tabs): "Scheduled"
And this is the information I would like to automatically update: "Equipment Tracking"
I'm ready for your help!
