Is there a way to get the value of a custom field instead of the label when building a calculated field?

[Kurt_Jones]

My example, I have a drop-down field, countries where I have a value and label set up, such as Australia (label=Australia value=AU), United States (label=United States value=US), and so on.  I would like to use the value in a Calculated field but not sure how to get to it or if that is possible, anyone know?

[Doug_Den_Hoed__AtAppStore · Accepted solution]

Hi @Kurt_Jones,

If a calculation uses the label by default and you'd prefer the value (or vice versa; I'm away from my computer, but from memory), I usually use a series of IF statements to decode the desired translation.

Regards,

Doug

[VictoriaSellers]

We run into this problem a lot (especially with AEM integrations)...definitely wish there was an option to choose to show the label vs. value in a calculated field without needing to write out the IF/Replace statements.