Compare Text with List

[TE21]

I am so confused I have read about IF() IN() INDEX() SORT() and thought I had this figured out but I am completely stuck.

I am trying to compare the text of Project Contacts[Name] to the list of Contacts[Full Name]. If the [Name] matches the [Full Name] then I need to copy the Contacts[ID] into Opportunities[ID]. I have setup a bot to do this but where I am is lost is shown in the image below. Some of the formulas I have tried are below but they all give me erroe “Cannot compare Text with List in ([Name] = Contacts[Full name])”

Any help is much appreciated!

IF(IN
(Project Contacts[Name], Contacts[Full Name]
),
[Name]=CONTACTS[FULL NAME],CONTACTS[ID],UNIQUEID())

IF(
Index(
Sort(
Contacts[Full Name], TRUE),1)
(Project Contacts[Name]
),
[Name]=CONTACTS[FULL NAME],CONTACTS[ID],UNIQUEID())

INDEX(Project Contacts[Name], Contacts[Full Name],IF([Name]=CONTACTS[FULL NAME],CONTACTS[ID],UNIQUEID()))

[Marc_Dillon]

Please check out these SELECT and LOOKUP help docs, I’m betting these are actually what you’re looking for.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

Also review this thread:

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[blacksweetbanan]

convert the list using expression Text(value-to-conver-to-text),

hopefully it works