Hello, I have a simple yet challenging problem here.
For brevity's sake, let's just say I'm starting with a company LinkedIn URL.
I have an enrichment column that scrapes it: “Company Data”
I have an evaluation column that determines whether it meets a particular criteria YES or NO: “Evaluate”
Then I have another column that simply has that result: “Results” and EVERY CELL either has a YES or a NO.
Then, in my email validation column, it is ONLY supposed to update IF, the Result value is YES.
However, when I put that formula into the update logic as a required condition and “preview” the formula, it ends up returning SOME of the rows as null values, even though they ALL have either a yes or a no.
Why is that happening ?
