I want to take the value from any one of these (which ever one has a value) and minus the amount entered in the field called "Discount Amount connection charge" which is custom field - currency. and enter the result into the "CC after discount" field.
One record type is a Field Survey. I want to build a formula that stats if the custom object record type is field survey and that the action field is updated to "complete" that three other custom fields are required. But I am lost, new to Salesforce so any help greatly appreciated
AND ( OR ( ISPICKVAL($ObjectType.Work_Order__c.Fields.RecordTypeId , "Field_Survey"), ISPICKVAL( Action__c , "Complete"), ISBLANK( Cabling_Cost__c )))
The error message "Error: Incorrect parameter for function ISPICKVAL(). Expected Picklist, received Object"
I want to take the value from any one of these (which ever one has a value) and minus the amount entered in the field called "Discount Amount connection charge" which is custom field - currency. and enter the result into the "CC after discount" field.
One record type is a Field Survey. I want to build a formula that stats if the custom object record type is field survey and that the action field is updated to "complete" that three other custom fields are required. But I am lost, new to Salesforce so any help greatly appreciated
AND ( OR ( ISPICKVAL($ObjectType.Work_Order__c.Fields.RecordTypeId , "Field_Survey"), ISPICKVAL( Action__c , "Complete"), ISBLANK( Cabling_Cost__c )))
The error message "Error: Incorrect parameter for function ISPICKVAL(). Expected Picklist, received Object"
Does anyone have an S-Control or Formula that will take a start date and add a duration in months to calculate an end date?
I've tried handling this in SF itself through a workflow rule trigger by breaking out the dates into MM DD Year fields and manipulating that way. The problem is of course Validating the end date is a true since the current work around causes a problem. ie: Jan 31 2007 + 1 Month = Feb 31, 2007 ... not a valid date.
Since we have Admin Support SF personnel tried to write a formula for the calculation and after a few weeks gave up and told me the only way to handle this is with a Custom S-Control.
