Hello, I have a formula
ITEM01 & “-”& ITEM02 & “-” & ITEM03
and this is what i get?
But my values are all 2 digit numbers, but for some reason they are all being appended with I_
As shown Bellow?
Result
I_05-I_40-I_00
Need
05-40-00
Any ideas?
Thanks
Hi @rjp - it sounds like the fields you’re using are Single Option fields right?
Currently, their “internal” name is what’s shown when used in a formula, which is what you’re seeing there actually.
Do you need that field to be a Single-option field?
Thanks for reply. Yes it is an option field i have made them into text field and that works but not as clean a solution as i would like,