Hi there,

I’m trying to replicate some spreadsheet conditional formatting for some data that I require publishing with some specific rules around precision - I can’t seem to replicate this using the functions that are available in Airtable (or so I think).

Has anyone found a way to display numbers in formats like this:

Rules:


If < 1, then 2 decimal places.


If < 10, then 1 decimal place,


If >= 10, then 0 decimal places.

So in theory I would get the following numbers:


0.1623 -> 0.16


0.2688 -> 0.27


1.2344 -> 1.2


3.3759 -> 3.4


12.6984 -> 13

etc.

I have tried using ROUND(Value,if(value<10,1,0))

But as this ultimately depends on the precision setting this doesn’t display what I need.

Is there a way to recreate an excel function;


=TEXT(Value,if(Value<10,“0.0”,“0”))

Any tips would be appreciated!