I'm calculating number of years someone has been a member.
The formula I'm trying to construct will say:
If the picklist value is cancelled, calculate the end date minus the start date then divide by 360 to give me a number of years value. If the picklist value is NOT cancelled calculate today minus the start date divided by 360.
I'm not sure how to construct this formula...any help is appreciated!!
6 个回答
You'll have to change the API Field Names to match the ones on your SFDC Org, but this formula should give the result you asked for in your post.
Datetype: Formula(Number,0)IF(ISPICKVAL(Picklist_1__c , "Cancelled"),
(End_Date__c - Start_Date__c) / 360,
(TODAY() - Start_Date__c) / 360)
