Hello Austin

Thank you for your purchase.

Unfortunately, what you're looking for to achieve cannot be successfully done.

That column cannot be created as a float column, which has correct numerical sorting, but you created it as a string-type column. String type columns have alphabetical sorting, and they cannot follow the same rules numerical columns follow (integers and floats).

Hello again Austin

Unfortunately, it wouldn't help.

The format of the floats cannot be adjusted to display values like that. What you can try, though, would be to save the data as Floats, which would then use the correct sorting.

If you do that, you would need to create conditional formatting rules for all your entries, so they are replaced by strings. Your front-end users would see the strings, like 00.xx and 0.x, while actual data will be floats.

That's the only way you can achieve this.

Hi again Austin

Unfortunately, that's something we cannot influence. Basically, float columns can only have one length, so if you set it to have 4 decimal places, 0.008 should come out as 0.0080. I'm not sure why you're not seeing it like that.

Conditional formatting rules can overwrite each other if one has higher priority, and that's not something I can help you with unfortunately. As for the slider - it is always going to show the actual values, not the masked ones.