What's the easiest way to make a numbered column going sequentially 1 through the end of the list? (I.E. Row one would have 1, row 2 would have 2, etc.) I know it can easily be done in excel by just dragging the cells down, but is there a easy way to do so in clay?
You can create a sequentially numbered column using a formula in Clay. Here's how:1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type something like "Create a sequential number starting from 1 for each row" 3. Click "Generate Formula" 4. Review the sample output to ensure it's creating the sequence you want 5. Click "Save Formula" to apply itMake sure to set the column's data type as "Number" for proper formatting:1. Right-click the column 2. Select "Edit Column" > "Select Data Type" 3. Choose "Number" 4. Click "Save Settings" Sources: Select Column Data Type Formulas