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
Help Article Resources
Check out the Formula Handbook template!