Alternating Names for SDRs Using Column Logic in HubSpot | Clay

Alternating Names for SDRs Using Column Logic in HubSpot | Clay

Clay Support
APP
·
·
You can create alternating SDR assignment using a Formula column with the modulo operator: [1]
1.
Add a new column and select Formula
2.
In the AI Formula Generator, describe: "Alternate between two SDR names based on row position"
3.
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.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
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?
John F.
·
·
No it didn't. Neither is working
Clay Support
APP
·
·
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.
Intercom
APP
·
·
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!
Loading attachments
John F.
·
·
https://app.clay.com/workspaces/571718/workbooks/wb_0t3dbuznyDEviEz5XHQ/tables/t_0t3s2mddgM3rvKjeF8j/views/gv_0t3s2mdFuCjTWXcfaox
John F.
·
·
I just need a way to return A then B then A then B... alternating in successive rows..
John F.
·
·
Hi you can ignore this-- I just found the enrichment that does this
John F.
·
·
FYI your answer bot should reference that enrichment instead of the formula answer!!
Izzy
·
·
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 :)
Hari K.
·
·
No worries!
John F.
·
·
Ok thanks!
John F.
·
·
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?
Izzy
·
·
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 :)