...didn't find the answer yet, but it turns out there's a bug in the program. Somehow "Space.Name" is mixed up and is actually reporting a different data field...it's reporting the "Occupancy Organization" instead. The default value of "Occupancy Organization" is Custom, just like it is for "Space Name". When I change the "Occupancy Organization" the value I enter actually shows up in the Space Name column in the schedule.
How do you report bugs like this?
Also, I found the Vectorworks manual has some good info on how schedules and worksheets work, but still no sign of a list of data fields that can be used in formulas.
I'm still hoping someone out there has the answer to this.
Braith