Wow. Not good design, imho. If it's going to concatenate the 2 names, it needs to be able to do it. Not do it sometimes and not others. The way it is, a report that includes account names looks like junk. To get a clean report, a user can't use sub-accounts. That means a reporting tool is dictating an accounting structure, which makes no sense whatsoever.

Unless, that is, there is some way to strip the parent account name that I've not been able to find. And believe me, I've tried every which way I can think of to strip it out. The only thing I haven't tried is hard-coding, but that makes the smartsheet capability pretty much useless.