Troubleshooting Formula for Conditional Column Execution in Clay

Juan O. · 2024-11-25 17:36:51.309427+00

Hey guys I am trying to implement a run setting on which the column "Street Name" will only run if "Virtual Tour Availability Response" and "Virtual Tour Availability 2" have the word "No" however, when I implement the formula using AI, none of the columns will run, any ideas why?

Troubleshooting Formula for Conditional Column Execution in Clay | Clay

5 comments

· Sorted by Oldest

Channeled
APP
·
·
To help with your conditional formula, let's break down how to properly set this up: 1. Go to the Run Settings of your Street Name enrichment column. 2. In the "Only run if" box, click the "Use AI" button to help create your formula. 3. When writing your condition, make sure to: • Use "/" to properly reference your columns (e.g., "/Virtual Tour Availability Response") • Clearly state your condition: "Only run if /Virtual Tour Availability Response contains 'No' AND /Virtual Tour Availability 2 contains 'No'" 4. Click "Generate Formula" to create the proper syntax.If your column still isn't running, double-check that: ** The column names are exactly as they appear in your table ** The word "No" matches the exact formatting in your data * The generated formula syntax is complete and unmodified Sources: Guide: Ways to Save Clay Credits - Clay University Conditional Formulas
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bo (.
·
·
Hey! I just checked and noticed you've made some changes to the column settings. Everything seems to be working now from what I can see - though I'm not seeing that "Virtual Tour Availability 2" column you mentioned. Want to share what you're currently seeing so I can help troubleshoot? 🔍 https://downloads.intercomcdn.com/i/o/w28k1kwz/1265295917/a4c8b43251888b8307c3f9afd02b/CleanShot+2024-11-25+at+_135YRe317y%402x.png?expires=1732564800&signature=b0d8fa856683b239fbe69403c04332e1abb37ade7a84c3a504c17dfe78810774&req=dSIhE8t3mIheXvMW1HO4zVa%2F8wntLr5If9NbcfrpvenoQr6ZZ2MO3aE%2Bl55a%0ATMy6%0A
Channeled
APP
·
·
Hi Juan O.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Juan O.!

Channeled
APP
·
·
To help with your conditional formula, let's break down how to properly set this up: 1. Go to the Run Settings of your Street Name enrichment column. 2. In the "Only run if" box, click the "Use AI" button to help create your formula. 3. When writing your condition, make sure to: • Use "/" to properly reference your columns (e.g., "/Virtual Tour Availability Response") • Clearly state your condition: "Only run if /Virtual Tour Availability Response contains 'No' AND /Virtual Tour Availability 2 contains 'No'" 4. Click "Generate Formula" to create the proper syntax.If your column still isn't running, double-check that: ** The column names are exactly as they appear in your table ** The word "No" matches the exact formatting in your data * The generated formula syntax is complete and unmodified Sources: Guide: Ways to Save Clay Credits - Clay University Conditional Formulas
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bo (.
·
·
Hey! I just checked and noticed you've made some changes to the column settings. Everything seems to be working now from what I can see - though I'm not seeing that "Virtual Tour Availability 2" column you mentioned. Want to share what you're currently seeing so I can help troubleshoot? 🔍 https://downloads.intercomcdn.com/i/o/w28k1kwz/1265295917/a4c8b43251888b8307c3f9afd02b/CleanShot+2024-11-25+at+_135YRe317y%402x.png?expires=1732564800&signature=b0d8fa856683b239fbe69403c04332e1abb37ade7a84c3a504c17dfe78810774&req=dSIhE8t3mIheXvMW1HO4zVa%2F8wntLr5If9NbcfrpvenoQr6ZZ2MO3aE%2Bl55a%0ATMy6%0A
Channeled
APP
·
·
Hi Juan O.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Juan O.!