Can anyone chip in on how to have a conditional formula to 'only run w...

Can anyone chip in on how to have a conditional formula to 'only run when' the row number is an even number? Tried searching the group and testing the ai formula maker but can't seem to get it right

5 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hey Alex, thanks for reaching out! The row number is currently not detectable by any other feature in Clay but you could assign a number with a formula column or even randomize a 1 or 2 for each lead, then you can condition columns by this assigned number.1st prompt would be something like: "Return a random number between 1 and 2 if /column1 is not empty"2nd prompt: "run only if /randomNumber is 2"
Clay Team
APP
·
·
Hope this helps!
Alex
·
·
is there a way to do this without wasting an additional column though Arturo O.
Clay Team
APP
·
·
Sorry for the delay, Alex! Unfortunately, no. As mentioned, that row number is not detectable at this time but will ask for the reason or if it can be enabled/used as a condition