Using conditional formulas would be best for this, here's a quick video on how to use them/set them up - https://www.clay.com/learn/how-to-use-ai-formulasIn this case, though, you would add the conditional formula to the column where you're extracting the value, asking the formula generator to output the value if it exists, otherwise to print N/A if empty
