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

(Marc Dillon) #1

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) #2

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

(Aleksi Alkio) #3

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

(Steven Coile) #4

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).