Clay formulas support standard JavaScript, Lodash, Moment.js, and Excel/Google Sheets functions, but there isn't a specific built-in variable for current row numbers. [1]
However, you can add a column named "Row Number" using a number generator to create row numbers, which can then be referenced in other formulas or used for filtering.
Are you looking to use row numbers for a specific purpose like filtering data or creating conditional logic?
Add a new column: Scroll to the right of your table and click Add column [1]
2.
Select Number data type: In the column creation dropdown, specify Number as the data type [2]
3.
Name it "Row Number": Give your column a clear name like "Row Number"
4.
Set up the number generator: Configure it to generate sequential numbers starting from 1
Once created, you can use this Row Number column for filtering - just click Filter above your table, select the Row Number column, and set conditions like "greater than or equal to" your desired starting row
This gives you precise control over which rows to include in searches or other operations.
When you add a new column and select "Number" as the data type, Clay automatically sets up sequential numbering starting from 1. [1] The number generator creates row numbers that correspond to each row in your table, which you can then use for filtering data starting from specific rows.
Just name your column "Row Number" and it'll generate 1, 2, 3, etc. for each row automatically.
Apologies for the confusion here, but Clay currently doesn't support creating a sequential number generator for each row. This is a request that we have gotten from a lot of customers and is on the current product roadmap. Let me know if this clarifies things and if there is anything else I can help with today.
