Formula to show Latest Date @row

A Rose
A Rose ✭✭✭✭✭
edited 07/16/21 in Formulas and Functions

Hi,

I have a column that has a list of customers and date column next to that, each client is there a few times because they have a few dates,

Any formula to only see the latest dates, so I can delete the others?

Thank you!

Answers

  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭

    What I have done based on historical community questions on finding the most recent entries is

    • Add an Auto-Number column (any format)
    • Add text/number column called "Row #" with the formula below entered in it

    =MATCH([Auto-Number]@row,[Auto-Number]:[Auto-Number],0)

    • Add checkbox column with the formula below in it (this will check the box of the most recent entry)

    =IF([Row #]@row=MAX(COLLECT([Row #]:[Row #],[Client Name]:[Client Name], [Client Name]@row)),1)


    There is probably an easier way, that is just the one that worked best for me when I was looking a few months back for a way to indicate the most recent entry

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!