I'm having some major trouble trying to round robin to SDRs-- is there a way to create alternation logic in a column prompt? I have an input column with two SDR names / Hubspot IDs -- I want to return a second column that alternates between the names (returns one name, then the other, then back to the first.. etc. Or A then B then A then B -- in successive rows. I'm seeing some formula logic around the row number-- but these are not sorted on successive rows, so it's not purely based on the next row. Is there a way to get a formula or AI enrichment prompt that will just return A then B then A then B in successive outputs???? Thank you in advance!
You can create alternating SDR assignment using a Formula column with the modulo operator: [1]
Add a new column and select Formula
In the AI Formula Generator, describe: "Alternate between two SDR names based on row position"
Use this formula structure: if (ROW() % 2 == 0, "SDR_A_Name", "SDR_B_Name") The ROW() function gives each row a sequential number, and % 2 creates the alternating pattern (0,1,0,1...).
Alternatively, use Use AI enrichment: [2]
Select "Content creation, manipulation"
Reference your SDR column with / and create a prompt like: "Return the next SDR in alternating sequence from these two options: {SDR_Names}"
Both methods will give you consistent A-B-A-B alternation regardless of row sorting.
Did that answer your question?
If you need any more help with setting up the alternation logic or have other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
No it didn't. Neither is working
I'm sorry to hear that the solutions didn't work for you. I'll connect you to a human agent who can assist you further.
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
I just need a way to return A then B then A then B... alternating in successive rows..
Hi you can ignore this-- I just found the enrichment that does this
FYI your answer bot should reference that enrichment instead of the formula answer!!
Hey John! Sculptor will point you to the round robin enrichment you are using. Wanted to share in case you have similar questions in the future - Sculptor can help you find an enrichment to use and it has context of your table so could be more effective in its answer agreed with you that our support bot should also reference that enrichment :)
No worries!
Ok thanks!
Also I notice the round robin isn't exactly a 50/50 - so in other words sometimes it goes A, B, A, B, and then will sometimes do A, A, B, A, B, B, B, A... is that just the settings, or am I missing an input on my end to equalize the results?
Hey John F.! It won’t necessarily assign A,B,A,B consecutively in that order but what you can do to check that it actually “round robined 50/50” properly is by asking Sculptor to tell you the count of how many rows got assigned to A vs B. Sculptor is also pretty awesome at data analysis like this for your table :) If you want to more manually confirm, you can also create a filter to only show rows that got assigned to A and same for B and then compare the # rows :)
