Need help in sorting data on a table from smallest to largest like the EXCEL RANK function

Hello Everyone,
I need help please see below.
What formula can I use to determine the rank of the number from the total number of orders?
Let’s say I have 98 numbers and each number is given a random decimal when it is entered. How do I determine their rank that is updated every time a new order is entered?


It’s not supported by our standard tool since our formulas can’t reference values from other entries. The easiest way would be sorting the entry based on the “Random No.” field.