Just trying to display the text string "1/6" ...

[Marc_Dillon]

Just trying to display the text string “1/6” here. None of the 3 examples in the photo work. Why is it converting it to a date automatically? Note that this is just an example post, the actual string is inside of a longer expression, and thus I cannot just set the column type to something else.

It works by using “1”&"/"&“6”

Very strange.

[Aleksi_Alkio]

Where do you want to use that string? With the app formula?

[Aleksi_Alkio]

If you use it for example with the virtual column, you can type just like… ‘“1/6”’

[Steven_Coile]

AppSheet is likely interpreting the string as a date. As you’ve discovered, you have to work around the magic. This’ll also apply if you have two or three short numeric strings separated by colons (that look like a time value).