AppSheet automatically converting text values to date values in formulas

[Chris_Bellamy]

Hello all,

I was attempting a lookup for the Display Name property of one of my columns.  I attempted to look up a value of "1.1.1", and in doing so AppSheet must be seeing that value as a date automatically, and is attempting the lookup using a date value instead of just the text value.  The field I'm attempting to lookup is correctly a text format, and not a date.

How can I lookup a value of "1.1.1", or "1.2.1" without AppSheet thinking it's a date?

Thank you!

[Steve]

This is AppSheet trying to be helpful and missing the mark. It should only affect raw values, not values stored in columns. To avoid it, you have to disguise the value so AppSheet doesn't think it's a date. Any trivial expression that produces the desired result will do. For instance, ("1" & ".2." & "1").

[Joseph_Seddik]

What is your expression please?