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?


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!