What are the 'Order' options for RANKEQ and RANKAVG?

Options

Hey,

I could likely come up with this if I sat down and experimented with the formulas for a while, but I really feel like they should be listed somewhere and better documented and I'm really hoping someone else has already done the legwork. I don't even know if 'order' serves the same purpose in both formulas.

  • RANKAVG says "order—[optional] The arrangement to use to evaluate the range"
  • RANKEQ says "order—[optional] The method to evaluate the range"

What are the possible values?

What are their impacts?

What is the default if no order is declared?

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @P_Youderian

    Great question! This is specified in the functions when you're typing them into the sheet, but you're right, the Help Articles don't have this detail written out. I've submitted feedback on these articles so we will update them in the future.

    • The values are either 0 or 1.
    • 0 is descending order.
    • 1 is ascending order.
    • 0 is the default.



    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓
    Options

    Hi @P_Youderian

    Great question! This is specified in the functions when you're typing them into the sheet, but you're right, the Help Articles don't have this detail written out. I've submitted feedback on these articles so we will update them in the future.

    • The values are either 0 or 1.
    • 0 is descending order.
    • 1 is ascending order.
    • 0 is the default.



    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!