How to Add a Conditional Column Based on No Companies Found Text Display

·

if I want another column to run only when there is text that displays "No Companies Found" in this column, is there a way to do that, without looking for an empty ID value - I don't want the new column to run unless the Lookup Company has run for the row.

✅1

32 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Augustin R.
·
·
Have you tried adding a Conditional Formula in the run settings?
Nick S.
·
·
or if theres a way to exclude running a new column for rows that have "run condition not met" that would be great
Nick S.
·
·
yes I've tried, can't figure out a way to do it
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_8ONS8hJBtbHF/views/gv_v9l4RjsMIPZU It;s the enrich linkedin company column
Nick S.
·
·
I keep getting the "infinite loop" error
Clay Team
APP
·
·
You can do the following as a workaround, filter like this
3d3e6db7-52b1-4afc-bb29-dae43b1e3b1e.png(176 kB)
Clay Team
APP
·
·
download as a csv
Clay Team
APP
·
·
upload again in a new table
Clay Team
APP
·
·
and perform a lookup: The Lookup Record integration can help with that. Here's a video and our docs page for Lookup Record!
Clay Team
APP
·
·
A bit tedious but this will fix the issue
Nick S.
·
·
thanks
Clay Team
APP
·
·
I tried other things like formulas but wasn't detecting the fields
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo How do I create a lookup based on the apollo ID written from another table and populate all the columns that would have been updated using the "enrich person" column on this table
Nick S.
·
·
or do I have to write over everything that I need, it's just that there might be times when I don't write over something that I later need in my person table, so better if possible to populate the table with a lookup from the apollo id....