I have used it to rollup text depending on the hierarchy level selected by a user. In the example below, forecasts are entered at department level with commentary (level 3).
Depending on the level users select, I use text list to summarize commentary entered
You can get more fancy providing commentary overrides along each level so when a user drills up and down the hierarchy they are shown the appropriate detail/summary of information
@rob_marshall I understand you advise not to use textlist but if you can show me how to achieve the result above via another mechanism. As part of the transformation above I do you use first non blank as well
Commentary is a different story and in your case, you would most likely need to use Textlist() if the Commentary was truly free text. With that said, if you can get away from using Text as well as TextList, then your model will perform better. I understand you just mocked something up, but if the "text" can be made into a list, like if they were stock answers or status's instead of using Text, then you can most likely model it.