How to have a report to show newest row only?
![Blain J](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I am creating a survey form to be filled out every 2 weeks with new information. Then displaying this information on a dashboard, but I only want to show the most recent update/entry on the dashboard. I have the dashboard, survey form, and report set up but how do I configure the report to only show the newest or most recent entry? That way when it shows up on the dashboard it only shows 1 entry, the newest?
Answers
-
May I assume each survey entry arrives in your sheet at the top?
If so, could your sheet or report include a 'helper' column such as a checkbox with a formula that results in 'true' (checked) for row 1 and 'false' (unchecked) for any other row? Something like IF(@row=1, 'true', 'false')
The report filter can then be utilised.
Hope this makes sense and is helpful.
Hope this helps and that you have a great day,
Jason Albrecht MBA, MBus(AppFin), DipFinMgt
LinkedIn profile - Open to work
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives