You need to sign in to do that
Don't have an account?
Samir Mahtani 4
Help - The formula expression is invalid: Syntax error. Found '='
I'm converting a few processes into flows. all of them have a field update using a formula that was working fine in the process builder. For some reason when I copied and pasted it into the new flow, I received the following error:
The formula expression is invalid: Syntax error. Found '='
Here are the formulas I pasted:
First Formula:
{!ContractEndDate}=ADDMONTHS([zqu__Quote__c].zqu__StartDate__c,[zqu__Quote__c].zqu__InitialTerm__c)
Second Formula:
= IF([zqu__Quote__c].zqu__InitialTerm__c = 60,"Five-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 48,"Four-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 36,"Three-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 24,"Two-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 12,"Annual",
IF([zqu__Quote__c].zqu__InitialTerm__c = 6,"Bi-Annual",
IF([zqu__Quote__c].zqu__InitialTerm__c = 3,"Quarterly",
IF([zqu__Quote__c].zqu__InitialTerm__c = 1,"Monthly","False"))))))))
3rd Formula:
[Opportunity].Total_Contract_Value_v2__c - ([Opportunity].Opportunity_MRR_v2__c * [Opportunity].Contract_Term_in_Months_v2__c)
4th Formula:
= [Opportunity].Opportunity_MRR_v2__c * 12
5th Formula:
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Lite") , "Lite",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Starter") , "Starter",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Essential") , "Essential",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Platinum") , "Platinum", "None"))))
The formula expression is invalid: Syntax error. Found '='
Here are the formulas I pasted:
First Formula:
{!ContractEndDate}=ADDMONTHS([zqu__Quote__c].zqu__StartDate__c,[zqu__Quote__c].zqu__InitialTerm__c)
Second Formula:
= IF([zqu__Quote__c].zqu__InitialTerm__c = 60,"Five-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 48,"Four-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 36,"Three-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 24,"Two-Year",
IF([zqu__Quote__c].zqu__InitialTerm__c = 12,"Annual",
IF([zqu__Quote__c].zqu__InitialTerm__c = 6,"Bi-Annual",
IF([zqu__Quote__c].zqu__InitialTerm__c = 3,"Quarterly",
IF([zqu__Quote__c].zqu__InitialTerm__c = 1,"Monthly","False"))))))))
3rd Formula:
[Opportunity].Total_Contract_Value_v2__c - ([Opportunity].Opportunity_MRR_v2__c * [Opportunity].Contract_Term_in_Months_v2__c)
4th Formula:
= [Opportunity].Opportunity_MRR_v2__c * 12
5th Formula:
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Lite") , "Lite",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Starter") , "Starter",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Essential") , "Essential",
IF(CONTAINS([zqu__QuoteChargeSummary__c].zqu__Product_Name__c, "Platinum") , "Platinum", "None"))))
Can you please share the scree shot where you are trying to add this formulas. One main important is that in formula is the below may not be supported in flow.
The = symbol is causing the issue in your flow. If you share the screenshot then I guess it would be more helpful for experts to answer it better.
If this solution helps, Please mark it as best answer.
Thanks,