Two fields are available in account object
I have the Picklist datatype Value in one field called custom__c
Picklist Values are:
atom, molecule, organic, inorganic
I have created the another formula field called custom1__c with return type as text
if i create the record in the object
if i choose the value atom in custom__c field another field called custom1__c it should populate the small value in that field
like wise
if i choose
atom- small, molecule - big, organic - material, inorganic - nonmaterial
should automatically populate in the custom1__c field, can you guide me the answer what is the formula i have to write when creating the field called as custom1__c as formula for populating the values