The formula reads:

=IF(([Potentially Impacted]="N/A")
    ,CONCATENATE("Potential Business Impact is to:"
                 ,[Potentially Impacted Units]"
                 ,"  "

and I keep getting the following error message. The formula contains a syntax error or is not supported. Learn more about the syntax for formulas.

Troubleshoot issues with Microsoft SharePoint Foundation.

  • Looks like you're missing a quotation mark before [Potentially Impacted Units] Dec 1 '15 at 18:56

I reformatted your formula, easier to read and the mentioned quote is more obvious. linebreaks and space will be ignored when you save the Formula.

It can be shortened to:

=IF(ISBLANK([Potentially Impacted])
    ,"Potential Business Impact is to:"&[Potentially Impacted Units]&"  "

This Bookmarklet helps with checking formulas while you type

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.