I've attempted the following, but get a Syntax error of Missing ")" before "Trimont"
(IF(Estimated_Current_Year_Revenue__c, ISBLANK(TRUE), ISBLANK(FALSE) (Trimont_Approx_1st_Yr_Revenue__c / 365) * (DATE(2018,12,31) - Estimated_Close_Date__c)
I'm also open to suggestion if there is an easier way to allow this field to calculate and be editable.
Thank you all in advance.
Shelby
2 件の回答
PS. a Formula field can't be edited, and that Formula will not work in a Default Value Formula. For what you described it sounds like you need a Workflow Rule or Process that is triggered if the Estimated_Current_Year_Revenue__c field is not blank. Then add an immediate action (Field Update) that updated your field using this Formula
(Trimont_Approx_1st_Yr_Revenue__c / 365) * (DATE(2018,12,31) - Estimated_Close_Date__c)
