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! 

L_123

try using:

=Max(Collect(

I've posted a reference below on how to use collect

https://help.smartsheet.com/function/collect

@SPark

That is perfect, thank you!!