Is there a way to automatically assign a label to a folder regarding the folder contents, i.e always automatically assign a label to folders which have archives in it.
It could be done using a Script Column which returns true or false (or whatever you want) after checking the folders. Labels can refer to script columns as part of their criteria.
Doing that could cause unwanted disk access every time a folder was read, though. It would have to list every sub-folder every time (a bit like folder size calculation or the total size columns do). (That would be true however it was done, not just with the method I'm proposing.)