pgreene31’s Profile

Community member since November 2018




I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. 

I can easily get the MIN Date, However, many columns are in the past. I want the


For example, the value in column 4 row 2 is "xxxxx_email address=[email protected].com_xxxxx"

The value in column 2 row 2 is "[email protected]"

I need a formula that checks if column 4 row 2 contains "email address=[email protected]" by crosschecking the value in column 2 row 2 and using the text string "email