Max Collect latest date based on 2 criteria


I am trying to get the latest date to populate by using MAX and COLLECT based off of the Zone being Ambient, and the Floors checkbox being checked.

This is what I currently have: =MAX(COLLECT({When}, {Where}, Zone@row, {Floors}, =1))

Here is where I am pulling the data from:

And here is where I am hoping to have the date populate:

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!