MAX(COLLECT({Range 1}, {Employee Range}, @cell = Employee@row))
Answers
-
@Paul Newcome Could you update this formula for two ranges? For example If we needed to know the latest date by name and by review type. For example, if there were another column review type with two values "performance" or "development", and I need to find the latest date for Paul's performance review.
Thanks in advance!
-
Hi @LydiaB1029
With a COLLECT function, all you need to do is add the next {column range} and "criteria" with a comma in between to filter.
=MAX(COLLECT({Range to Max}, {Column 1}, [First Criteria]@row, {Column 2}, [Second Criteria]@row))
Does that make sense? So in your case something like:
=MAX(COLLECT({Date Column}, {Name Column}, Name@row, {Review Column}, Review@row))
If this hasn't helped, it would be useful to see a screen capture of your source sheet, but please block out sensitive data.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Great, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!