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
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!
Did that answer your question?
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?
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
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!
Is that what you were looking for?
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?
