Max Date - Collect for the last entry


I am not even sure where to start today..

I want to collect the last date for the entry in the Solution #31 column. But this column should only have entries once per week (amongst 30 plus entries on the other items on the sheet).



  • kioshi43
    kioshi43 ✭✭✭

    Normally you can try something like:

    =MAX(Date:Date) to pull whatever is the most recent date within that range but when you're saying you want to have entries once per week, could you expand upon that?

  • Elizabeth Aird
    Elizabeth Aird ✭✭✭✭

    There will be entries throughout the week. But for that particular column, only ONE entry is required for the week.

    There are entries every two hours (if the plant is running). So 12 line items per day x 5- but I just want to see the last time Solution 31 was verified by date.

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭

    @Elizabeth Aird

    I would recommend creating a helper date column (let's call it "Z") and run an automation which records a date in column "Z" whenever an entry is made into the Solution 31 column, then you can run the =MAX(Z:Z) formula which @kioshi43 suggested above (but change the "Z" column name to the name of your new automated date column).

    Let me know if that works or if you need additional assistance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!