Multiple initial values to reference

[Cristhian_Macia]

Hi,

I am trying to generate a reference column from another reference for various selection options, but it only allows me to reference once and not the three I need as seen in the formula image

Which expression would work for all three to apply?

[Steve]

help.appsheet.com

CONCATENATE()

Merged text from parts

[Cristhian_Macia]

@Steve

I only need to reference one, not all at once, but I need all of them to be available due to the different selection options of [Tipo]

[Steve]

Ah.

help.appsheet.com

SWITCH()

Chose-one conditional evaluation