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? https://app.clay.com/workspaces/238722/workbooks/wb_QbSQf4nfbty3/tables/t_q5UnTUfwXPW7/views/gv_2a8dxSDN5woZ
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
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!
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
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!