.png){kind=logo}
How to Add Row Number in Clay Formula with a Conditional Filter
Hey everyone! I am trying to add row number in the clay formula. Can I have a filter like - Run only if row number > 250?
Hey everyone! I am trying to add row number in the clay formula. Can I have a filter like - Run only if row number > 250?
You can set up this condition using the "Only run if" option in the Run Settings of your enrichment column. Here's how: 1. Go to the Run Settings of your enrichment column 2. Find the "Only run if" box 3. Enter a formula that checks the row number condition You can use the "Use AI" button in the Run Settings to help you write the formula in plain language, making it easier to set up the condition without complex formula syntax. This approach will help you conserve credits by ensuring the enrichment only runs on rows after position 250, preventing unnecessary enrichments on rows that don't meet your criteria.
It does not recognise row number as a separate column
Unfortunately, row number is not directly available as a column for filtering in Clay. Instead, you can use one of these approaches: 1. Add a new formula column to create row numbers: • Click "Add Column" • Create a formula that assigns sequential numbers to your rows • Then use this new column in your "Only run if" condition 2. Use the Filter feature: • Click "Filter" above the table • Select your row number column • Choose "greater than" and enter "250" • This will filter your view to only show rows above 250 These methods will help you conserve credits by ensuring enrichments only run on the rows that meet your criteria.
How do I create a formula to assign sequential number?
Can you provide a formula to me?
You can create sequential row numbers using Clay's AI Formula Generator. Here's how: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type something like "assign sequential numbers starting from 1 for each row" 3. Click "Generate Formula" 4. Review the sample output to ensure it's creating sequential numbers as expected 5. Click "Save Formula" to apply it to all rows Once you have this column with sequential numbers, you can use it in your "Only run if" conditions for other enrichments.
Source: Formulas
It throws error that you must use atleast one column in your formula
To create sequential row numbers, you'll need to reference at least one existing column in your table since Clay formulas require column references. Here's what you can do: 1. First, add a new column and select "Formula" 2. In the AI Formula Generator, use any existing column in your table by referencing it with "/" 3. Type something like: "Create a sequential number using /[any_column_name]" 4. Click "Generate Formula" 5. Review the sample output to ensure it's creating sequential numbers 6. Click "Save Formula" to apply it If you don't have any columns yet, you'll first need to add some data to your table. You can do this by clicking "+ New Row" at the bottom of your table to add data.
No
Hey Sophiya! Thanks for reaching out. Happy to help✨. To clarify, formulas are not able to evaluate based on row numbers in Clay. To evaluate correctly, it has to be based on a cell value. However, you can manually filter your table/apply a sort to show rows from number 250 and run integrations within that view. Could you share more about your use-case? Happy to share tailored suggestions.