Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Duplicate rank what formula would return the most recent week?

I have a formula to return the date of the 5 highest ranking weeks. Two weeks are both ranking as the 5th week as they both have the same result. Currently it is returning the oldest of the two dates. Is there a way to get the most recent week instead?

Tags:

Best Answer

  • Employee
    Answer ✓

    Hi @B Young

    I agree with Paul! You could use a MAX function, however I would put this in an MAX(COLLECT formula instead of VLOOKUP.

    Try something like this:

    =MAX(COLLECT([Week Column]:[Week Column], [Rank of boxes ticked]:[Rank of boxes ticked], Rank@row)


    I'm not sure what your Week Column is called, so you may need to replace that with the column that has your dates. Let us know if that worked for you!

    Cheers,

    Genevieve

    Need more information? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions