Formula result is "N/A". Automation does not seem to evaluate it properly

electrichead

Hi, I have a formula in column C such that:
=IF(ISBLANK(column A), column B, column A)

column B is also a formula, and the result is sometimes N/A. In the column B formula this result is written as "N/A", so it comes in as text with no leading or trailing spaces.

Also, column A, B, and C are all multi-contact columns.

When I set a condition in my Automation, it doesn't seem to evaluate properly. For example, if I set a condition around column C like this: where column C has none of: N/A
Somehow I still get the result from the next action.

Is there a trick to the logic here? The logic worked when the cell was empty and I could say column C is not blank, but I've been forced to populate N/A's in all the blank cells.

Thanks for any help!

Adrien Leduc

Hi @electrichead , yes the automation usually doesn't "read" well the system error message, the trick is to use the IFERROR formula (perhaps in your column B directly).

Do something like : IFERROR(Your formula,"Error")

Then change your automation to use Error instead of N/A, it should work.