Compare Text with List

AppSheet AppSheet Q&A
, ,
1

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!

3X_d_a_da0cf73d3dabb1caa24b17456eab70982d7e690d.jpeg
3X_d_a_da0cf73d3dabb1caa24b17456eab70982d7e690d.jpeg1660×932 85.3 KB

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()))

1 Like
2

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

Also review this thread:

[Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table](https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column-values-in-the-entire-table/50771) 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…

1 Like
3

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

hopefully it works