IN function, need guidance

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.

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

2 Likes

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

1 Like