I'm running into a situation where a Site Collection has several sub sites. Each sub site has data related to a particular geographical region. When trying to create content types / site columns for use in each site's document libraries, naming conflicts in site column names become inevitable.
For example:
Site A - Create a site column with the name of "Field Office" that is a lookup to a list on Site A.
Site B - Create a site column with the name of "Field Office" that is a... whoops, can't use this name because its already being used by Site A.
I guess we could use something like "Field Office [Geographical Region]", but that starts to look a bit odd on the SharePoint list forms, re: we already know we're in the geographical region, why is the form re-stating that?
Further, there are sites in the site collection that are represented by Division; these sites will have Site Columns with a "Field Office" as well.
What have you done in the past to overcome this limitation?