Solved: Cannot compare Text with List in ([...] = [_THISRO... - Page 2

Ryan_Hagler · 09-04-2023 09:31 PM

I've got the age old problem of "Cannot compare Text with List in ([...] = [_THISROW].[...])", but I can't for the life of me figure out why. I've used the formula a million times but I'm not sure what I'm doing wrong here. Here's the full formula:

if(isblank([Email]),any(select(Contact[Email],[Contact]=[_THISROW].[Contact])),[Email])

Two Tables:

This table - Customers

Other table - Contact

Just trying to have it display [Email] from Contact table when Customer[Email] is blank.

Ryan_Hagler

Alright, pretty sure I've got it now. Tested and seems to be performing correctly.

if(isblank([Email]),any(select(Contact[Email],in([Contact ID],[_thisrow].[Contact]))),[Email])

Just a heads up, the IN() formula did not work until I used the ID column [Contact ID]. The Label column, Contact[Contact], would not work even though I imagine it is supposed to return the ID when referenced from another table. Either way, this is working.

View solution in original post