Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mano sfdcMano sfdc 

Need Help For Formula Field

Hi All,

I have three fields.

Month__c -> Denotes month value (Ex. Jan, Feb etc)
Year__c -> Denotes Year value (Ex. 2013, 2014 etc)
Bill_Month__c -> Formula field need combination of both Month+Year (Ex. Nov 2013)

Please find below image.

User-added image

Thanks in advance.

Thanks,
Manohar
lakslaks
Hi Manohar,

Assuming that Month__c and Year__c  are text fields, the formula Month__c  +' '+  Year__c should work for the formula field Bill_Month__c.

Regards,
Lakshmi.
lakslaks
Kindly mark it as the solution if it solved your problem.

Thank you.

Regards,
Lakshmi.
Mano sfdcMano sfdc
Hi Lakshmi,

Thanks for your reply.
Please see Month__c and Year__c fields are picklist.
It should be like picklist only. Because every field having picklist values.
C. Praveen kumarC. Praveen kumar
If they both are picklist fields, then change the above formula as 
TEXT(Month__c)  +' '+  TEXT(Year__c)



Kindly mark it as the solution if it solved your problem.

Thank you.