Obtain Most Recent Value based on date of within Month

Preston B
Preston B ✭✭
edited 06/21/23 in Formulas and Functions


I am trying to obtain the most recent membership entered for the month, where the value doesn't matter if largest. The formula will be used to calculate the most recent membership of the month, for the calendar year from the Report Date.

I was able to use =MAX(COLLECT({Membership}, {Month}, "January")) but comes out to 300 and not 275. I can't seem to figure out the formula needed to modify.

{Membership}= Membership Value

{Month}=Month Helper Column


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!