Skip to main content
Topics#Data ManagementPergunta de Shelby Verzinskie
Shelby Verzinskie (Trimont Real Estate Advisors) perguntou em #Data Management
14 de mar. de 2018, 13:13

Formula Help Please

I am attempting to create a formula field in which a calculation will be done if it is left blank, but no action will be taken if information is hardcoded to the field.

 

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 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    14 de mar. de 2018, 13:24
    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)

     

     
Escrever uma resposta...
0/9000