Text Object Box

[evansabres]

Hello -

I have a text object box in which I have the field 'cmpMNTH' representing a campaign month. When I make a selection, my desired return is to have that text object box say the month the campaign started. However, for certain categories, there may be multiple months that could be returned. Is there a way to have the box essentially have an if statement, so that when there is more than one month, the box either returns, multiple or Jan, Mar, Aug?

Not sure if this is possible.

Thank you,

Evan

[sunny_talwar]

May be use this:

=Concat(DISTINCT cmpMNTH, ',')

[stigchel · Accepted solution]

You can use the Concat function for this e.g.

=Concat(DISTINCT cmpMNTH,',')

[evansabres]

Thank you, this helped.

[evansabres]

Thank you, this helped.