I have a table with a column "Size". I have s...

[Benoit_Gramond]

I have a table with a column “Size”. I have spaces before the size in my database (in order to sort by "

S", " M", “L”).

When I use this table in Appsheet (That comes from my ERP’s database so not possible to change), the spaces are automatically deleted.

Is there a way to avoid the Delete of the spaces before my size?

SOLUTION: A virtual columns like:

IF([Taille] =

S,

CONCATENATE("

",[Taille]),

IF([Taille] =

M,

CONCATENATE(" ",[Taille]),

[Taille]

) )