Filter Companies by Revenue in Table with Custom Column

·Dec 19, 2025 07:13 PM·

can i build a column that filters for a value that is not currently inside my table? i have a large list of companies, in one step id like to pull their revenue and filter by that revenue, ideally it just keeps the companies that have revenue over a certain threshold

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You can use conditional runs to pull revenue data and only keep companies above your threshold in one step.
Set up your revenue enrichment with a conditional formula like {{revenue}} >= 1000000 to only run for companies meeting your criteria. This way the enrichment only processes companies that pass your filter, keeping your table clean.
Alternatively, you can pull all revenue data first, then use the Filter feature with "greater than" or "greater or equal to" operators to show only companies above your threshold.
Try using Sculptor in the top-right corner - it can help you set this up quickly!
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help setting up your revenue filter or using Sculptor, I’m here to assist. Would you like to share more details about what you’re trying to achieve with your table?
Taimoor A.
·
·
use Ai formula in the formula bar and write the prompt there it will create a the formula for you and that column work for you what u need
Clay Support
APP
·
·
Exactly! You can add a new column, select Formula, then use the AI Formula Generator. Just type what you want to do in plain language - like "only show companies with revenue over $1M" - and use "/" to reference your revenue column. Click Generate Formula and it'll create the logic for you.
This is perfect for filtering by revenue thresholds without needing the data in your table first. Try Sculptor in the top-right corner too - it can help set this up even faster!
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with setting up your revenue filter or using the AI Formula Generator, I’m here to assist. Would you like to provide more details about what you’re trying to accomplish so I can support you further?

Clay Support
APP
·
·
Yes! You can use conditional runs to pull revenue data and only keep companies above your threshold in one step.
Set up your revenue enrichment with a conditional formula like {{revenue}} >= 1000000 to only run for companies meeting your criteria. This way the enrichment only processes companies that pass your filter, keeping your table clean.
Alternatively, you can pull all revenue data first, then use the Filter feature with "greater than" or "greater or equal to" operators to show only companies above your threshold.
Try using Sculptor in the top-right corner - it can help you set this up quickly!
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help setting up your revenue filter or using Sculptor, I’m here to assist. Would you like to share more details about what you’re trying to achieve with your table?
Taimoor A.
·
·
use Ai formula in the formula bar and write the prompt there it will create a the formula for you and that column work for you what u need
Clay Support
APP
·
·
Exactly! You can add a new column, select Formula, then use the AI Formula Generator. Just type what you want to do in plain language - like "only show companies with revenue over $1M" - and use "/" to reference your revenue column. Click Generate Formula and it'll create the logic for you.
This is perfect for filtering by revenue thresholds without needing the data in your table first. Try Sculptor in the top-right corner too - it can help set this up even faster!
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you still need help with setting up your revenue filter or using the AI Formula Generator, I’m here to assist. Would you like to provide more details about what you’re trying to accomplish so I can support you further?