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.