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
-
You should be able to do this with 2 helper columns.
- Create an auto-numbered columns, let's call it "Row ID"
- 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
-
You should be able to do this with 2 helper columns.
- Create an auto-numbered columns, let's call it "Row ID"
- 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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!