# Rank Function

✭✭✭✭✭

Hi,

How do I create a rank formula for the field, that only includes certain values from a row that meets certain criteria.

For example the below image is the example. I only want to rank and include in the range active expenses. Can someone please help me.

Regards

J Tech

##### If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

• Overachievers Alumni

In order for it to work, I had to create a helper column that removed the Expense if the Status wasn't Active (mine isn't formatted as \$, but it can be)

"Value Expense" =IF(STatus@row = "Active", [Total Expense]@row, "")

Then I created the Ranking column looking at the Value Expense Column:

=IF(STatus@row = "Active", RANKEQ([Value Expense]@row, [Value Expense]:[Value Expense]), "")

If I didn't eliminate the "Obsolete" value, it was included in the ranking, even if it didn't show in the column (see the numbers in the Expense Rank column)

• Overachievers Alumni

In order for it to work, I had to create a helper column that removed the Expense if the Status wasn't Active (mine isn't formatted as \$, but it can be)

"Value Expense" =IF(STatus@row = "Active", [Total Expense]@row, "")

Then I created the Ranking column looking at the Value Expense Column:

=IF(STatus@row = "Active", RANKEQ([Value Expense]@row, [Value Expense]:[Value Expense]), "")

If I didn't eliminate the "Obsolete" value, it was included in the ranking, even if it didn't show in the column (see the numbers in the Expense Rank column)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!