Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell.
Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell:
I am using the COLLECT function to show the contents of a column of sheet A in sheet B. Both sheets have a few columns in common. In some (but not all) of the cells, Smartsheet adds a trailing space, which breaks the COLLECT function.
Some additional information:
- The values in the left column are added using the API, but I am sure that the input data does not include trailing spaces.
- Double-clicking the cell removes the space (as is standard Smartsheet behavior) and resolves the issue.
Is there anyone else who has experience with this issue? Thanks in advance.