TM1 Forum

I have a cube that has a number of picklists in it. They're mostly categorization things.

But once the picklist is on the cell, the only way to do input to the cell is to use the picklist.
I know that sounds stupid but ...
If I have 10 items that I need to categorize all the same category, I need to do them one at a time, which involves opening the drop dow2n and fishing the needed item out of the list. One of the lists is several dozen items long.

I'd like to be able to just copy a cell where I have already made the selection, then just paste it to another cell.

I've moved this to the enhancement sub forum as this is more of enhancement request rather than a cry for help.

If we are having a picklist enhancemnet thread then I'd like to be able to pick a blank when I point the picklist at a TM1 object like a subset.

How about using TM1Tools? Last time I checked the "paste clipbord data to formulas" functionality worked quite nicely against cells with picklists.

Also, I believe it's possible to just paste any single value over a formula with a picklist and it should send the value without overwriting the formula. The only problem I noticed with this and using the TM1Tools functionality is that the picklist validation is not doing its job with pasting, so it's a way for sneaky users to go around the picklist validation and input "incorrect" data.

And - get this - it's even possible to clear values this way (just paste a string containing one space over your formula cell), although when using picklist the normal way it's generally impossible (unless these are static picklist with an empty value specifically listed in the definition).