Only pull newest value of primary column into report

I use a grid smartsheet with form input to track audits for locations within my hospital. I need to keep all the inputs in the tracker, but only have the most recent audit appear in my report. Help!

Best Answer

  • Jason Tarpinian
    Jason Tarpinian Community Champion
    Answer ✓

    You should be able to do this with 2 helper columns.

    1. Create an auto-numbered columns, let's call it "Row ID"
    2. Create a checkbox column "Most Recent" with the formula: =IF([Row ID]@row = MAX([Row ID]:[Row ID]), 1, 0)

    That will only check the row with the largest "Row ID", which would be your latest entry. Then just filter your report to "Most Recent" is "Checked".

Answers

  • Jason Tarpinian
    Jason Tarpinian Community Champion
    Answer ✓

    You should be able to do this with 2 helper columns.

    1. Create an auto-numbered columns, let's call it "Row ID"
    2. Create a checkbox column "Most Recent" with the formula: =IF([Row ID]@row = MAX([Row ID]:[Row ID]), 1, 0)

    That will only check the row with the largest "Row ID", which would be your latest entry. Then just filter your report to "Most Recent" is "Checked".

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!