MAX? IF(S)?

Options
@SPark
@SPark ✭✭✭
edited 12/09/19 in Formulas and Functions

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! 

Past Due by Person - Smartsheet.com 2019-11-07 14-16-59.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!