Lee A.

Says updating cells, has been for 12 hours+

It is the 5th column from the end

Table here: https://app.clay.com/workspaces/232715/tables/t_YfnvHA4exUCC/views/gv_UjQeCXEe5p9n

Also this is causing an infinite apparently: {{New Column}} || [“A”, “C”, “E”, “G”, “I”, “K”, “M”, “O”, “Q”, “S”, “U”, “W”, “Y”].includes({{Person - Name}}?.[0]?.toUpperCase()) ? 1 : 2

Anjali D.

Which came up with this formula: {{Row Number}} + Math.floor(Math.random() * 2) + 1 But it says can’t save because of infinite loop….🤯

I’ve just added this prompt: this column should have a random number of either 1 or 2 added so that the table is roughly 50% of each

Hmm will try that, thanks!

Hi Anjali D. Rubi S. I am looking for an automated process. I want to use 2 different automations for the snippet. Maybe I create a formula that if the first name starts with A, C, E, etc, run X and if it starts with B, D, etc, run Y. I am looking to have variety within the content creation with as much automation as possible. Would this work?