I am trying ti create a calculated column where it will add the vale "has been completed" if the approval column is approved. Below are the code and screenshot of the error.

Thank you

    =IF([Approval Status]="Approved","has been completed")

enter image description here


1 Answer 1


You do not have a FALSE clause as third IF parameter but that is no error, should default to FALSE.

Most likely you need the ; (semi-colon) as separator and not a , (comma)

  • Thanks, Danny, But when I put semicolon says 'you have a syntax error in the formula'. Nov 16, 2016 at 12:34
  • So add the False output Nov 18, 2016 at 10:22

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.