Is there a way to use ISBLANK to print out those rows that ARE blank ?

ChrisVilella

Okay, so basically I used

=CHOOSECOLS(FILTER('Building Doors/Parking'!A2:D40,'Building Doors/Parking'!D2:D40=H1),1,2,3,4)

with a dropdown menu, and i'm able to see loaded trailers, empties, return trailers, OOS ( out of service trailers ) etc...

I'm only missing one piece to making this so helpful for my building.

I need to be able to print the rows that ARE empty, so that we know which empty slots we have available for incoming shipments.

Our rows look like this :

I want to be able to print the 13D row to show that it is an empty slot in our yard.

Or any workaround idea would be appreciated.. thank you!!

ChrisVilella

This is what I currently have, if it is helpful to solve this. Like i said, the same way it is printing the row and showing what is in it's respective position, i want to change the menu that has "empty", and add an option that will populate the table with empty slots.