+ Start a Discussion
Poorna DeveloperPoorna Developer 

Formula Field to display value in the number field



Hi all,

I have an object called (Object1) 'Vechiel' and that has following fields like -  'Age'-(Number) 'Type'-(Picklist) and Max_Term-(Number). 
And one more object called(Object2) - 'Application', which  has 'Age_of_Vehicle'-(Number), FacilityType-(Picklist) and Term(Formula Field).

Whenever I choose Age_of_Vechicle and FacilityType from Application object that need to fetch data from Max_Term(Object 1)  and display in the Term field which is in the Application.

Need forumla field to validate this one, Any help.
Thanks.
CharuDuttCharuDutt
Hii Poorna 
In This If FacilityType(Picklist) is equal to yes Then Only Term(field) get populated with Max_Term(field) value
IF( ISPICKVAL( FacilityType, 'Yes') , Object1__r.Max_Term, null)
Please Mark It As Best Answer If It Helps
Thank You!