Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

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

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

5 comments

· Sorted by Oldest

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 (Clay)
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