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.

Andrée Starå

Hi @ChrisVilella

I hope you're well and safe!

Not sure I follow! Can you elaborate?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!