Conditional search and return

My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique "Primary" group, and when there are no keywords present for the group, I would like to return an early date, e.g. 1970-01-01.

I have had no luck with combinations of 'IF(),' 'MIN(),' 'MATCH(),' and 'INDEX()' -- I could theoretically do this with an SQL-esque type query, but am unsure how do so or if that is possible.

Any tips?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!