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;
Any idea or workaround that I can have the same outcome like in GoogleShee?, Thanks.
If you want to keep the value as number or decimal, we donโt have direct way to do that.
IFS(Decimal([Data])<[Low],โLowโ,Decimal([Data])>[High],โHighโ)
@Aleksi_Alkio Now it works!! you helped me twice after the โinitial valueโ question !! Big Thanks.
Youโre welcome
One more time @Aleksi_Alkio the condition above (with App Formula) works for โUpdateโ only because we already have โLowโ and โHighโ data to compare.
But for adding new data, I think the App Formula is faster than Spreadsheet formula that I use to get the โLowโ and โHighโ data (vlookup(RC5&RC3&RC4,โOther Tableโ!R2C1:R999999C8,7,0) that cause the calculation is wrong for new data.
Is it possible to put vlookup in the App Formula? because I
tried to add to the โLowโ and โHighโ column but seems not workingโฆ
@Aleksi_Alkio Please ignore my previous question above, I found the way to add LOOKUP into the App Formula now everything is solved for both Adding & Updating
@Aleksi_Alkio any indirect way,put some script on Data?
Script wonโt help, but you could use TEXT column for this purpose and if you need to calculate with that value, you can use DECIMAL([Column]).
@Aleksi_Alkio I set โDataโ to be Text, and โLowโ & โHighโ to be Decimal like below on Spreadsheet formula; ========== IFS(RC(Decimal([Data]))<RC[Low],โLowโ,RC(Decimal([Data]))>RC[High],โHighโ) ========== But I think it still doesnโt workโฆ
It doesnโt work in what way?
@Aleksi_Alkio The calculation is still wrong, when I put lower or higher value in Data field, the Compare field still not changeโฆ
What is the meaning of โRCโ in here?
You want to use sheet formula instead of an app formula?
@Aleksi_Alkio Actually I donโt mind, because I tried App formula sometime it doesnโt workโฆ
FollowingโฆIโve been wondering the same thing
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |