Check for Duplicates, Compare Dates of Duplicate Rows, Display Date Furthest in the Future

Options

Hello,

I have a sheet where I'm in-taking data from grad students signing up for access to lab rooms. They provide us with their begin and end dates. Sometimes they will resubmit the form when their end date changes and they're at the university longer.

I've made a helper column called Duplicates that checks a box when there are duplicates of the Identifier but I'm having trouble getting to the next step which is displaying the End Date in a new column that is the furthest in the future of a duplicate row.

Thank you,

Stefanie

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!