MAX? IF(S)?
@SPark
✭✭✭
Hello!
I'm trying to figure out a formula to return the highest value from a range as long as it matches certain criteria. In the screen shot's example-- I want (in column 'Highest Day Late') to return the value of the highest past due date based on the range only if it includes the name from the Primary Column.
Please help!
Tags:
Comments
-
try using:
=Max(Collect(
I've posted a reference below on how to use collect
-
That is perfect, thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 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!