A stocktake sheet has one column for the room and one for the rack. Make a printable label in C2 while leaving the two inputs available for filtering.
Join two required fields
With Workshop in A2 and Rack 3 in B2, enter =A2&" / "&B2. Read back Workshop / Rack 3 and check that the slash has a space on both sides.

Illustrated room-and-rack label. Keep the input columns available for filtering.
Flag incomplete labels before printing
If either cell is required, use the version below in C2 and fill it down.
=IF(OR(A2="",B2=""),"Check location",A2&" / "&B2)Clear the rack in a scratch row and expect Check location. Clear the room instead and expect the same message. If an import contains cells filled with ordinary spaces, test TRIM(A2)="" and TRIM(B2)="" in the condition to catch those too.

Illustrated validation check for a missing rack.



