Only pull newest value of primary column into report

Mary.Thurber

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!

Jason Tarpinian

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".

Jason Tarpinian

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".