I have a simple IF statement that produces a null value when it shouldn't be. I’m trying to get it to replace what should be an email address with a value of “missing sample data” with a null string so that when I include it in the “To:” line for an email it doesn’t produce an error. In this case, there is a valid email address and it is returning a Null value.
IF("{{196777846__assignedAMemail}}"="missing sample data","")
It doesn't appear to be executing because even if I change the "" at the end to a string like "XX" it still returns a null value. Below shows how it is configured, the test values and the result.
This was working previously and I don’t think I made any changes to it. Any thoughts appreciated!
