If you set Name to Collapse, you'll probably also want to set columns like Type, which can be quite wide, to Expand, so they go off the side instead of forcing the Name column to shrink too much.
This video explains in more detail: Tutorial video: Column resizing & folder formats