You need to sign in to do that
Don't have an account?
Megan Hooser 7
Formula syntax issue
Can someone help me figure out my syntax issues?
Looking to have the formula evaluate if the created date is greater then the date, run the first calucaltion, if the date was prior, run the second calcualtion.
IF(DATEVALUE(CreatedDate)>(6/20/2017),
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))
Looking to have the formula evaluate if the created date is greater then the date, run the first calucaltion, if the date was prior, run the second calcualtion.
IF(DATEVALUE(CreatedDate)>(6/20/2017),
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))
Please try the below
IF(DATEVALUE(CreatedDate)> DATE(2017,6,20),
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))
Please mark as best answer if the above helps ..!!
All Answers
Please try the below
IF(DATEVALUE(CreatedDate)> DATE(2017,6,20),
(Total_Material_Cost__c*(1+Proposal__r.Opportunity__r.Account.Mark_upproject__c)),
((Total_Material_Cost__c * 1.7241 ) * 1.07526))
Please mark as best answer if the above helps ..!!
Please mark as best answer ..!!! So that it closes the question and we can help keep the forum clean..
Thanks !!