Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Only show the most recent associated date in a report for a value that appears more than once
We are using smartsheet to track when facilities wihtin the organization are visited. Essentially, we have a form that employees fill out indicating which facility they went to and when they went there.
I am have created a report that will show all facilities within the organization that have not been visited in a specified time period.
I am wondering if anyone knows if it is possible to only the show the most recent visit date for a facility visit? I don't need duplicates showing showing but I have not figured out how to do this if possible.