Does using JOIN with the End Date field that is part of a dependency not work properly?

I am trying to MATCH on two fields, so I am using JOIN to make one field.

The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match.

Is that END date causing this problem?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!