Kashif J.

No worries! I'll tentatively mark this as closed for the moment, but do keep in touch if you hit other roadblocks!

I've added a correct formula following the second option in this "test column" at the end of your table. I'd recommend you to double check it and see that it all makes sense within the context of your use case and table though before implementing it fully!

I would recommend choosing the latter option, as changing the type of a column will cause all downstream cells to re-run or become stale

So the issue, (after pressing the "explain" button on the run condition not met sidebar), is that the current "Exclude job title" column is currently a string, but the formula is expecting a Boolean True/False value. The fix here would be to change the "Exclude Job title" column into a boolean, or to change the filter to search for a string not for an actual False value.

Hi Denver, Taking a further look into this now

Also apologies as I noticed I sent a screenshot of the lookup multiple rows in other table, instead of the lookup single row in other table column. However, to set up the example above, your Lookup row in other table column (in the people table) would look like this:

Table: Companies table Target column (where you're looking in the Companies table): Company Domain Filter operator: Equals Row Value (the value in the People table which you are looking for in the companies table): /[the column where you have the company domain of the person in that row] Let m eknow if this helps

Hi there,

Sorry for the confusion here, as I'm not sure if I'm understanding your use case. I wanted to try and clarify how this works using a simple example:

Imagine you have two tables: a Companies table and a People table. You want to pull company information into the People table when a person works at a company that exists in the Companies table. To do this, both tables must share a common identifier, such as the company domain or a HubSpot company ID.

For example, if John works at Clay and you have an enriched Clay row in the Companies table, you need a reliable way to link John’s row in the People table to that specific Clay row. The domain can be used for this purpose. You would look up the row in the Companies table where the domain column equals clay.com.

This means the company domain must exist in both the Companies table and the People table. Once that shared identifier is in place, you can reference the matching company row and access all of its data, including any specific columns, directly from the People table.

Let me know if this helps clear anything up, or if I'm not understanding your use case?

So you want to use a "/" to reference another column, there should be a dropdown menu that handles this like so:

Let me know if this makes sense!

From here: Inside of your Contact table, you would then lookup a single row in your company table, using the Company HS ID as the lookup.

Here's a mockup of what the Lookup Single row in other table column would look like.

Let me know if that makes sense here? If you can share some further context here on your exact use case and tables you'd like to send to and from

Hi Joshua, ​The way to go about doing this would be to use the lookup single row action. In this situation, as long as all of the rows in each of the tables you mentioned have the correct HS ID present in them, its similar to VLOOKUP functionality, where you look for the HS ID in a separate table, and return all the data in the row where that HS ID is a match. Essentially you would need something along the lines of: In your Company import table: The Company HS ID

In your Contact import table: The Company HS ID of the company where the contact works at.