I am trying to create a formula that concatenates the following fields:
mytext__c (text field) -- example: tt
mynumber__c (number field) -- example: 10
mypicklist__c (picklist field) -- example: no
I want to create a field "code__c
" which is a formula and looks like this:
tt-10-no
This is what I have right now:
mytext__c + mynumber__c + TEXT(mypicklist__c)
For some reason I am getting an error for the picklist though. Tia.