RANKEQ with a date criteria

Hi there,

I am trying to pull the most recent fee payment value from each regional group. I want this to pull through to a report so that I can see that most recent payment value In a report where all the regions appear once.

I have the region column (called DNO) the fee payment column (called A&D fees) and the date column to determine the most recent (DNO offer received). But I also have a days since column to help with the formula

I'm getting stuck pretty early as I don't know how to incorporate the date/ days since :

=RANKEQ([A&D Fees]@row, COLLECT(DNO:DNO, DNO@row, ))

Any help would be great


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!