To be honest I’m not sure if this is a bug or if I’m doing something incorrectly. I have a list of numbers stored in a cell to which additional items are added with a button formula using
ListCombine(). This works fine, but when I go in and try to edit the list (e.g. to remove an erroneous addition to the list), the list becomes text, and breaks formulas that use the list. Is there a way to keep this from happening?
I think a potential long term solution would be to have an “Array” column type, but I’m sure this would create other complexities.