I have a column named “Age” defined as Plain Text in the Google Sheet and Text in the AppSheet table that contains age ranges, e.g. 08-11, 12-17, 18-30, 31-50, 51-70 and 71+
I want to update an Initial Value in another column based on the contents of this column but the expression below returns FALSE.
IF([Age]=“08-11”,“n/a”,"")
This expression works on columns that contain alpha characters but not in the above case.
When clicking on the VERIFY button in the Expression Builder screen and looking at the results, it changes “08-11” to a Date “8/11/2018 12:00:00 AM”.
Is this a bug? Is there a work around?
LinkedIn
Twitter
