Does using JOIN with the End Date field that is part of a dependency not work properly?
Options
James Keuning
✭✭✭✭✭
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
-
Ugh. Nevermind. Turns out the 0 matters LOL.
-
Do you mean the 0 within the MATCH function? In any case, I'm glad you figured it out!
Cheers,
Genevieve
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!