Cross Sheet Reference

AshAddington

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()))

Paul Newcome

Invalid Ref comes from a cross sheet reference that wasn't create properly. Click in each reference and look for the "Reference Another Sheet" link. That will be the one causing the problem.