Column showing email address - only wanting to show one

[redbruno81]

Hi folks,

Trying to create a column with one email address in, it's currently showing 3, any idea of a formula to remove two of the addresses so I can send an automation?

[Sho]

Hi @redbruno81,

What type of field is the e-mail address?
With Lookup, you can limit the number of items displayed.
For others, you may need a formula.