Anyone got any suggestions for dealing with s...

Anyone got any suggestions for dealing with scientific notation numbers in appsheet? I would like scientific notation to be displayed, instead of a very large number. My first thought was just to have them be inputted and text strings, but then a small number of these fields will optimally need to be added together, thus they would have to be numbers. Does appsheet know how to handle this? I canโ€™t seem to find anything info about it.

0 2 318
2 REPLIES 2

Try converting the columns back to numbers when you have to calculate them. Something like NUMBER([column w/number as text]) + NUMBER([column w/number as text])โ€ฆ

@Michael Good suggestion, didnโ€™t see that function existed yet.

Top Labels in this Space