how do I do a filter so that if there are more than two people at the company, it will put that other persons first name in a new column called "personalization" i want to run a campaing where the hook I say "hey james! wasnt sure if I should reach out to you or cathy, but here we are" and I want cathy to be someone else on the team... preferably the person with hihg descion making power
You'll need to use a Formula column to create this personalization logic. Here's how:
Add a Formula column called "personalization" [1]
In the AI Formula Generator, describe your logic: "If the people list has more than 2 items, extract the first name from the second person in the list, otherwise leave blank"
Reference your people column using "/" to select it in the formula
For better targeting of decision-makers, you might want to first filter or sort your people data by seniority/title before creating this formula.
Try using Sculptor (top-right corner) to help build this workflow - it can generate the exact formula syntax for your specific table setup.
Is that what you were looking for?
so.... would i filter out my find people table to only people where there are atleast two people at company and then ?
Yes, exactly! First filter your Find People table to show only records where there are at least 2 people at the company. [1] You can use the Lookup Multiple Rows integration to count people per company, then filter where that count is >= 2.
After filtering, add a Formula column called "personalization" that extracts the first name from the second person in your people list - this gives you that "Cathy" for your hook. [2]
Try using Sculptor (top-right corner) to help set up both the filtering logic and the formula - it can generate the exact syntax for your table setup.
Did that answer your question?
i heard that formulas cant look across rows tho
You're right - formulas work within individual rows, not across them. For your use case, you'll want to use Write to Other Table instead. [1]
Here's the approach: Use Write to Other Table to map each person from your people list into separate rows in a new table, then you can easily reference the second person's name for your personalization column. [2] This "flattens" your people list so each person gets their own row.
Try Sculptor (top-right corner) to help set this up - it can generate the exact workflow for mapping your people data to a new table structure.
Was this helpful?
i hvae no idea
Let me break this down simply:
Filter your company table to only show companies with 2+ people
Use Write to Other Table to "flatten" your people list - this sends each person as a separate row to a new table [1]
In the new table, you'll have individual rows for each person, making it easy to grab the second person's name for your "Cathy" personalization [2]
Try Sculptor (top-right corner) - describe what you want and it'll build this workflow for you automatically.
Does that make more sense?
If you still need help setting up the filter and personalization column, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so we can continue?
thats not working.... how can we come up with a formula that if it checks if company domain is used more than once... then marks it yes in a new columb
You can't do this with a regular formula since formulas can't look across rows. Use the Lookup Multiple Rows integration instead:
Add a new column and select Lookup Multiple Rows
Set it to look up your company domain column within the same table
Configure it to count matches
Then add a Formula column that checks if the count > 1 and marks "Yes" [1]
Try Sculptor (top-right corner) - describe what you want and it'll build this workflow automatically. [2]
Is that what you were looking for?
If you still need help with setting up the formula or the lookup to mark companies used more than once, I’m happy to assist further. Would you like to share more about the specific outcome you want to achieve so we can continue?
