Clay Icon

Extract Row Numbers in Clay Table to a New Column

Β·
Β·

Is there any way to get row number of a clay table into a column separately?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Currently, we don't have a built-in feature to automatically add row numbers as a separate column. However, you can create a new column and use a formula to generate row numbers. Here's how: 1. Click "Add Column" > "Add Column using AI". 2. In the description, enter something like "Generate row numbers". 3. Set up the parameters to create a formula that increments for each row. 4. Click "Save" to add the new column. Alternatively, you can: 1. Insert a new column by hovering between two columns and clicking "Add Column". 2. Use the "Merge columns" feature to create a formula that generates row numbers. If you need further assistance, please request human help by clicking on "Talk to a person".

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hey Aaryan! Curious to know- why do you require a separate column with just the row numbers? I can definitely try to assist you here! Would love to get some additional context to guide you in the best possible way!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.