You need to sign in to do that
Don't have an account?
sasham
Formula field for finding date
Hi ,
We have Member__c obj and MemberState__C objects..MemberState__C has look up field for Member__c obj. I need to create formula field in Member__c obj. In MemberState__C obj , we having field state__c and date__c When the member is active very first time(since we many active state) ,
i need to popolate the formula field called startdate__c in Member__c using date__c in MemberState__C when state__c is active.. But we can have many active states in MemberState__C obj per member
We have Member__c obj and MemberState__C objects..MemberState__C has look up field for Member__c obj. I need to create formula field in Member__c obj. In MemberState__C obj , we having field state__c and date__c When the member is active very first time(since we many active state) ,
i need to popolate the formula field called startdate__c in Member__c using date__c in MemberState__C when state__c is active.. But we can have many active states in MemberState__C obj per member
If you cannot change the look up to master details, consider a process, maybe Flow or Apex trigger.
But actually we created look up field called memberState in Member__c to look up MemberState__C
If you do that, you will be able to create a Rollup Summary field on Member__c, that will enable you to view the earliest date__c in MemberState__C