how to find out oldest item by status?

I have a table that has fields like following

I need to create a metrics, that shows only the lines with oldest age of each statuses.

How can i create such metrics?


  • Paul H
    Paul H ✭✭✭✭✭✭

    Try This

    Add a new checkbox column and use this as its column formula.

    =IF([last activity on support ticket]@row = MIN(COLLECT([last activity on support ticket]:[last activity on support ticket], Status:Status, Status@row)),1)

    This should checkmark the only the oldest

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!