Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Feature Request: Rank order macro
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:
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.