I tried to set the data type to capture data ...

[Prayoon_Sonjai]

I tried to set the data type to capture data and compare with “Low” and “High” values as below (Data can be displayed with & without decimal in AppSheet).

But I found that the calculation in AppSheet will only work if the data type of “Data” set to either;

• Number - but I can’t put decimal value. - Decimal - but it will impact other values to display like 7.00 which I don’t want.

Any idea or workaround that I can have the same outcome like in GoogleShee?, Thanks.