How to reference a Contact in a table formula?

Community Discussions
#1

Hi,

I have a table that contains Contacts values and I want to add another column with a formula that establishes a value depending on the Contact Value, like this

image
image2208×330 52.4 KB

Is there a way to reference the Contact value from the other column?

#2

If matching by the display name doesn't work, one solution that comes to mind (and that I have used) is to have a separate table called eg. Contacts with the following columns:

  1. Contact: This is the contact itself
  2. Contact Identifier String: eg. "Diego Boet"

This way, your formula could read something like: IF(ListadoGastos[Pagador]=FINDROW(Contacts, "Contacts[Identifier] = %", "Diego Boet")[Contact], "OK", "NO")