IN function, need guidance

[Hattan_Hamoud]

Hi,

This is my formula: IN(CONCATENATE([Number],[Date]),Form Schedule[Visit Code])
The result of the concatenation is something like this 12345678909/08/2021
That number exist in Form Schedule[Visit Code] Google Sheet, but I get “False” as a result. Just in case, I took the result of the concatenation and did manual comparison in the google sheet and yes this value matches the one in the sheet.

Please help.

[Marc_Dillon]

Try to replace
[Date]
with
TEXT( [Date] , "mm/dd/yyyy" )

[Hattan_Hamoud · Accepted solution]

I did that previously and it didn’t work. I am not sure what was the problem exactly, but I redid the whole table out of frustration and it works now… Something was interfering with the comparison apparently.

Thanks for your support