We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro:
=rank(AQ3,AQ:AQ)
Smartsheets lets us score projects for priority but we would like to be able to use a Rank macro so we can refer to the ranked numerical order of the project (as opposed to just the total score of the projects).
In the example above, the macro compares the score in cell AQ3 with all other numerical scores in column AQ and determines its rank.