i want to select only 5 rows here what would be the formula ?

https://app.clay.com/workspaces/422263/tables/t_kKbWdHNy695h/views/gv_FXPw53k72Hk3

Hey Syed, thanks for reaching out! It appears this formula has been resolved, great strategy here! Let me know if you have any other questions, concerns, or need a hand setting up this workflow. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1296506546/7d613c2fb38e8ff62288cc3c5054/CleanShot+2024-12-13+at+10_19_49%402x.png?expires=1734104700&signature=f9d503c0326dc00c7b37d596fd191358f63f885abd98bfadb46721552a844eee&req=dSIuEMx%2Bm4RbX%2FMW1HO4zdgW48MmKUAg2xSFnkeFQn7EPuRm7qh1AUynxiTI%0AdZcp%0A

what is the formula to generate serial no.s in the column

Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

Are you looking to assign a unique serial number to each of your contacts or leads for easier reference later? or could you share more details about the specific use case for the serial numbers? :)

i want to run an automated sequence based on serial no.s so each 10 rows can be sent to different campaigns as in the screenshot although the reply automation sequence is executed by the no.s were input manually

also https://app.clay.com/workspaces/422263/tables/t_vSSJPtxUM8CU/views/gv_z4AEqWmFu3Uv in this table in the rows from 26-30 I ran an automation to send contacts to reply presently it is blank what I intend to do is I set the automation priorly and whenever data is added to the columns the automation should run and push to reply what could be the best way to do it

anyone here?

?

very slow response I must say everywhere ...hope I get the right answer whenever there is a reply hopefully

Hey Syed, apologies for the delayed response here. To confirm, the serial no.s would be used to create segments of leads to send to different campaigns. Makes total sense! In this case, assuming the assignment of leads to campaigns are random, I would recommend using our Round Robin feature instead. This would assign a value (or unique ID) to each campaign and then automatically assign each lead to a campaign randomly and evenly. Meaning, when a new segment of 10 leads come into this table, each of them would be randomly assigned to a campaign via this feature. While this wont be executed in the fashion you are describing, such as leads 1-10 go to campaign A then 11-20 go to campaign B, it would randomly assign and equally distribute these leads to each of the campaigns you have. https://downloads.intercomcdn.com/i/o/w28k1kwz/1299941584/0185174ad35807894ba9c50b1b16/CleanShot+2024-12-16+at+11_46_25%402x.png?expires=1734369300&signature=f323cdd729d82875cde98c7399ccb6042b4fd2cfb8c41e976251d3dd0a5baffb&req=dSIuH8B6nIRXXfMW1HO4zcCOEUvWQgy3XQTq4f5FOMXAoG2O%2Fh2AYrdlCckP%0AYwXA%0A