Hello,
I have a [PCN Checklist] that holds active and non-active PCN#'s. I need to check each PCN # on the [PCN Checklist] smartsheet to see if it's in any of the 3 other smartsheets:
[PCN Processing Log]
[PCN Archive Log 1]
[PCN Archive Log 2]
If it's not in any of these 3 smartsheets, it did not go through the PCN Process.
The columns in all 4 smartsheets is a text column with the title {PCN #}. However, 2 of the above smartsheets, the PCN # has a hyperlink attached to it. I've tried different formula's and also created a "Clean PCN #" column without the hyperlink and can't get it to work.
=IF(OR(ISNUMBER(MATCH([PCN #]@row, {PCN Processing Log Range}, 0)), ISNUMBER(MATCH([PCN #]@row, {Archived 1 Range}, 0)), ISNUMBER(MATCH([PCN #]@row, {Archived 2 Range}, 0))), "Match", "No Matches")
This returns: #No Match
It would be ideal if it could return the following if Matched or Not Matched per sheet:
Processing Log:
If matched return, "Matched Processing Log"
If not matched, return "Check Archive Log 1"
Archive Log 1:
If matched return, "Matched Archive Log 1"
If not matched return, "Check Archive Log 2"
Archive Log 2:
If matched return, ""Matched Archive Log 2"
If not matched return, ""Not Processed"
This might be a long shot.
Any help would be greatly appreciated!
Thanks in advance for your help!
