Date Match from another sheet
Options
ginamt3
✭✭✭✭
I'm trying to populate a date cell from another sheet. I used this fromula to find Names and it worked. I'm getting NO MATCH. I think it has to do with it being a date?
=IF(COUNTIFS({SHIPPED JOBS Root Job}, [Root Job]@row) + COUNTIFS({TRUE SOURCE Root Job}, [Root Job]@row) = 0, "Job Number Not Found", IF(COUNTIFS({SHIPPED JOBS Root Job}, [Root Job]@row) > 0, INDEX({SHIPPED JOBS Project Manager}, MATCH([Root Job]@row, {SHIPPED JOBS Root Job}, 0)), INDEX({TRUE SOURCE Project Manager}, MATCH([Root Job]@row, {TRUE SOURCE Root Job}, 0))))
Tags:
Answers
-
That means it is not getting a match on the [Root Job]. What happens if you use just the COUNTIFS broken out separately?
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!