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.