Sending an email if an email address isn't empty - failed

[emurobot]

Hi there, 

Here's the scenario: 

• I have an automation to send an email to the marketing contact if the 'marketing contact email' field isn't empty

• the 'marketing contact field' is a Rollup field with a formula of ARRAYUNIQUE(values)

• even though the 'marketing contact field'rollup field is empty, as you'll see from the test run on the below Loom, it still tried to execute that worflow. 

• is it seen as not empty because there's a formula in it?

https://www.loom.com/share/5b726b2bc41a414da662f055af863b55

[kuovonne]

Does changing the rollup formula to ARRAYJOIN(ARRAYUNIQUE(ARRAYCOMPACT(values)), ", ") help? This will clear out empty values and then force the result into a text string. 

[emurobot]

Thank you for the reply @kuovonne however it doesn't seem to have done the trick, as you can see below. 

You can see here that it says "if marketing email isn't empty" but then it clearly shows an empty field below!

[TheTimeSavingCo]

Try making your rollup formula `ARRAYJOIN(ARRAYUNIQUE(values))`? Seems to work!

Link to base

[kuovonne]

This is puzzling.

Could there be a record with a space in the email field that makes it look blank when it is not? 

Sometimes retesting the trigger helps.