Does Smartsheets have a Google PERCENTRANK function equivalent?


Hello, does anyone have a solution for the excel / google function “PERCENTRANK()” or the “RANK” function.  We want to consolidate our roadmap planning into Smartsheets and use one of these functions to automatically score from 1 to 10 each item in the list.  The below image shows how this is done today in Google.  The user can change the revenue and it is re-ranked based on how it is within the population on each change to the revenue amount.

PERCENTRANK(data,value, [significant_digits])



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!