Issue with Formula Not Pulling Results from HT 1st Run Column

·

Hello, any idea as to why this yellow formula column isn't pulling in the results from the column labeled "HT 1st run"? Here's the formula i'm using in the yellow column: [{{HT 3rd Run}},{{HT 2nd run}},{{HT 1st run}}].filter(Boolean).join(" ") Thanks!

1 comment

Clay
APP
·
·
If your formula isn’t pulling in results from the "HT 1st run" column, it could be due to missing or empty values in that column, or the formula is trying to process data that doesn’t exist for every row. Try adding logic to check if each referenced column actually contains data before joining them. Iterating on your formula and using the preview feature can help you identify where the issue is. Adjusting the formula or prompt wording may resolve the problem. If you need further help, you can request human assistance by clicking on "Talk to a person."
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Automated Inbound] - Clay University