Latest Date from column, if another column contains certain data

I have 2 columns: first column is a multi-select with multiple, the second column are all dates.

I want to pull the latest date by each of the items available in the multi-select

I figure its some combination of If, Large, and contains. but I'm at a loss on how to nest them together


thanks

Best Answer

  • Chris Mondeau
    Chris Mondeau ✭✭✭✭✭✭
    edited 05/28/20 Answer ✓

    Hi Jonathan,

    Maybe this is what you're looking for?

    I'm using the collect function to collect the array of dates for any row that contains the "multi" value, then returning the maximum/largest date from that set. (in the example I've highlighted the range for "dog" values).

    Here's the rest of the max dates:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!