You could do it using scripting but it would be fairly involved. Why not just toggle the column on to see if anything is in it, then toggle it off if it's not needed? You could make the button turn on the column and sort by it at the same time to quickly see if anything has status icons.
i agree. it would be great if the status column automatically appeared IF the directory had any items with label or status icon assigned. ive been digging thru the setting for a week and scrathing my head trying to figure out how to create an automatic filter for this. alas im just not a not natural at scripting.
i put the status column next to the name, otherwise if its empty i dont want to loose the space. .... or better yet, i just now thought of this, it would be nice and fun to have the empty column cell itself act as button that would open a context menu of just the labels\status ive been creating. ....now im getting carried away. ;-}
on a side note to creating status labels, i wish there were a what to create new\custom category related the to the type of media in creating them for. colors, status, and uncategorized are predefined.
^^^^^^ nevermind of that last paragraph. 1 minute after posting it i realized you just have manually type an new category name in the text\dropdown box.
Keep in mind that checking the whole folder for labels may result in slower performance, since it's not usually done (labels are only calculated as each file is displayed for the first time, i.e. when you scroll down).
If the labels are simple wildcards or similar then it may not be a big deal, but if you have complex labels that test things like file content or script columns then it might be different.
Which isn't to say "don't do that", just that if you see performance issues then you might want to limit which folders this is done in to avoid doing it in places it isn't needed or takes too long.
Place the mouse to the right of the column location where the Status column should be placed, right click and select the toggle. This also sorts on the Status column to bring any existing status to the the top. Right click on the Status column to toggle the column off.