Having trouble incorporating Data from our Land Agreement database into our Project Database so we're using formulas to work around this. There can be several Land Agreements per Project, so I want to find all rows with the same Project Name. Once I find all of them, return the next Land Agreement expiration. So greater than today but the minimum of that list of Dates. It's coming into a Text/ Number field and gives the Invalid Ref error currently. But I've also gotten UNPARSEABLE.
Formula is
=MIN(COLLECT({Expiration Date Range}, {Project Name Range}, FIND([Project Name]@row, @cell) > 0, {Expiration Date Range}, >TODAY()))
